{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Importando bibliotecas"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 31,
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import json"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Lendo os arquivos JSON com os textos extraídos utilizando a API da Elsevier. Para os aquivos provenientes de artigo cujo um dos autores é afiliado a uma empresa de Óleo & Gás foi acrescentado a coluna \"O&G\" com o valor 1 e uma coluna \"Affiliate\" com o nome da empresa. Para os demais artigos foi atribuído o valor 0 para \"O&G\" e \"outros\" para a coluna \"Affiliate\". "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 32,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Abstract</th>\n",
       "      <th>Creator</th>\n",
       "      <th>DOI</th>\n",
       "      <th>Date</th>\n",
       "      <th>Keywords</th>\n",
       "      <th>Title</th>\n",
       "      <th>O&amp;G</th>\n",
       "      <th>Affiliate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Melo, Marcel, Schluter, Helga, Ferreira, Jail...</td>\n",
       "      <td>10.1016/j.desal.2009.09.095</td>\n",
       "      <td>2010-01-30</td>\n",
       "      <td>[Reverse osmosis, Nanofiltration, Produced wat...</td>\n",
       "      <td>Advanced performance evaluation of a reverse o...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td></td>\n",
       "      <td>[Branco, Ricardo Castello, Baratelli, Fernando...</td>\n",
       "      <td>10.1016/j.jbiotec.2008.07.942</td>\n",
       "      <td>2008-10-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>Petrobras’ developments in biofuels</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Santos, Marcos Luiz Dos, Corrêa, Nelson Ferre...</td>\n",
       "      <td>10.1016/0021-9797(74)90239-2</td>\n",
       "      <td>1974-06-30</td>\n",
       "      <td>[]</td>\n",
       "      <td>Interaction of polyethylene with isobutane, is...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Lima, F.S.G., Araújo, M.A.S., Borges, L.E.P.]</td>\n",
       "      <td>10.1016/S0301-679X(03)00028-8</td>\n",
       "      <td>2003-09-30</td>\n",
       "      <td>[Lubricant base oils, Carcinogenic potential, ...</td>\n",
       "      <td>Determination of the carcinogenic potential of...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1000</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Barros, Maria A.S.D., Silva, E.A., Arroyo, P....</td>\n",
       "      <td>10.1016/j.ces.2004.07.040</td>\n",
       "      <td>2004-12-31</td>\n",
       "      <td>[Ion exchange, Zeolite, Modeling, Breakthrough...</td>\n",
       "      <td>Removal of Cr(III) in the fixed bed column and...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1001</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Rojas, Marisol Fernández, Bernard, Franciele ...</td>\n",
       "      <td>10.1016/j.molcata.2014.05.007</td>\n",
       "      <td>2014-10-31</td>\n",
       "      <td>[CO2 utilization, Poly(ionic liquid)s, Ionomer...</td>\n",
       "      <td>Poly(ionic liquid)s as efficient catalyst in t...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1002</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Mosquera, Juan C., Ghisays, Alfredo, Montes, ...</td>\n",
       "      <td>10.1016/S0016-7169(13)71475-2</td>\n",
       "      <td>2013-09-30</td>\n",
       "      <td>[caso histórico, modelado de pozo, tendencia d...</td>\n",
       "      <td>AVO analysis with partial stacking to detect g...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Piovesan, Enelise Katia, Bergue, Cristianini ...</td>\n",
       "      <td>10.1016/j.palaeo.2015.02.015</td>\n",
       "      <td>2015-04-15</td>\n",
       "      <td>[Palaeocology, Ostracods, Diversity, Sequence ...</td>\n",
       "      <td>Palaeoecology of ostracods from the Late Creta...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1004</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Quitete, Cristina P.B., Bittencourt, Roberto ...</td>\n",
       "      <td>10.1016/j.catcom.2015.08.013</td>\n",
       "      <td>2015-11-05</td>\n",
       "      <td>[Coking resistance, Nickel, Hexaaluminate, Tar...</td>\n",
       "      <td>Coking resistance evaluation of tar removal ca...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1005</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Filgueiras, Paulo R., Sad, Cristina M.S., Lou...</td>\n",
       "      <td>10.1016/j.fuel.2013.07.122</td>\n",
       "      <td>2014-01-15</td>\n",
       "      <td>[Crude oil, ATR-FTIR, Partial least squares re...</td>\n",
       "      <td>Determination of API gravity, kinematic viscos...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1006</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Dalmaschio, Guilherme P., Malacarne, Majorie ...</td>\n",
       "      <td>10.1016/j.fuel.2013.07.008</td>\n",
       "      <td>2014-01-31</td>\n",
       "      <td>[Petroleomics, Distillation system, Mass spect...</td>\n",
       "      <td>Characterization of polar compounds in a true ...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1007</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Castro, Aline M., Castilho, Leda R., Freire, ...</td>\n",
       "      <td>10.1016/j.bej.2014.10.016</td>\n",
       "      <td>2015-01-15</td>\n",
       "      <td>[Production of amylases, proteases, xylanases ...</td>\n",
       "      <td>Performance of a fixed-bed solid-state ferment...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1008</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Tannuri, Eduardo A., Silva, João Luis B., Ram...</td>\n",
       "      <td>10.3182/20100915-3-DE-3008.00052</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>[Dynamic Positioning, Crane Barge, Hydrodynami...</td>\n",
       "      <td>Methodology for evaluating DP crane-barge oper...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1009</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Alves, Douglas Thiago S., de Medeiros, Jose L...</td>\n",
       "      <td>10.1016/j.jlp.2016.03.026</td>\n",
       "      <td>2016-05-31</td>\n",
       "      <td>[Risk to general public, Major accident hazard...</td>\n",
       "      <td>Optimal determination of chemical plant layout...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Ferreira, Talles Souza, Araújo, Mario Neto Ca...</td>\n",
       "      <td>10.1016/j.marpetgeo.2014.02.012</td>\n",
       "      <td>2014-06-30</td>\n",
       "      <td>[Cumuruxatiba basin, Contractional Cenozoic sa...</td>\n",
       "      <td>Cenozoic folding in the Cumuruxatiba basin, Br...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1010</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Minette, R.S., SilvaNeto, S.F., Vaz, L.A., Mo...</td>\n",
       "      <td>10.1016/j.oceaneng.2016.07.054</td>\n",
       "      <td>2016-09-15</td>\n",
       "      <td>[Output-only modal analysis, Integration tests...</td>\n",
       "      <td>Experimental modal analysis of electrical subm...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1011</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Passamonti, Francisco, de la Puente, Gabriela...</td>\n",
       "      <td>10.1016/j.cej.2011.12.081</td>\n",
       "      <td>2012-02-15</td>\n",
       "      <td>[FCC, Catalyst evaluation, FFB, CREC Riser Sim...</td>\n",
       "      <td>Comparison between fixed fluidized bed (FFB) a...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1012</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Calixto, Ewerton E.S., Pessoa, Fernando L.P.,...</td>\n",
       "      <td>10.1016/B978-0-444-63428-3.50337-4</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>[H2S Scavenger, H2S Scavenger Software, Crude ...</td>\n",
       "      <td>A New Technology to Optimize the Use of H2S Sc...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1013</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Schmitt, William F., Szklo, Alexandre, Schaef...</td>\n",
       "      <td>10.1016/j.enpol.2011.02.067</td>\n",
       "      <td>2011-06-30</td>\n",
       "      <td>[Vehicle efficiency, GHG emissions, Land use c...</td>\n",
       "      <td>Policies for improving the efficiency of the B...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1014</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[dos Santos, Sidney Pereira, Eugenio Leal, Jos...</td>\n",
       "      <td>10.1016/j.enpol.2011.06.047</td>\n",
       "      <td>2011-09-30</td>\n",
       "      <td>[Natural gas industry, Investment analysis, Pl...</td>\n",
       "      <td>The development of a natural gas transportatio...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1015</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Melo, D.N.C., de Toledo, E.C. Vasco, Mariano,...</td>\n",
       "      <td>10.3182/20070606-3-MX-2915.00110</td>\n",
       "      <td>2007-12-31</td>\n",
       "      <td>[optimization, two-layer approach, genetic alg...</td>\n",
       "      <td>AN APPROACH TO OPTIMIZATION OF A THREE PHASE C...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1016</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Dellagnezze, Bruna Martins, Vasconcellos, Suz...</td>\n",
       "      <td>10.1016/j.bjm.2016.04.004</td>\n",
       "      <td>2016-09-30</td>\n",
       "      <td>[Bacterial diversity, Microbial enrichment, Pe...</td>\n",
       "      <td>Evaluation of bacterial diversity recovered fr...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1017</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Yamashita, André Shigueo, Alexandre, Paulo Ma...</td>\n",
       "      <td>10.1016/j.conengprac.2016.02.003</td>\n",
       "      <td>2016-05-31</td>\n",
       "      <td>[Model predictive controller tuning, Reference...</td>\n",
       "      <td>Reference trajectory tuning of model predictiv...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1018</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[de Paula Amaral do Valle, Pedro Wallace, Fort...</td>\n",
       "      <td>10.1016/j.biombioe.2016.03.036</td>\n",
       "      <td>2016-08-31</td>\n",
       "      <td>[Doehlert design, Hydrated ethanol, Phase evol...</td>\n",
       "      <td>A systematic multivariate analysis of the supe...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1019</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Menezes, Brenno C., Kelly, Jeffrey D., Grossm...</td>\n",
       "      <td>10.1016/j.compchemeng.2015.05.013</td>\n",
       "      <td>2015-09-02</td>\n",
       "      <td>[Oil-refinery production, Investment planning,...</td>\n",
       "      <td>Generalized capital investment planning of oil...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Fonseca, Felipe A.S., Vidal-Vieira, José A., ...</td>\n",
       "      <td>10.1016/j.biortech.2010.05.077</td>\n",
       "      <td>2010-11-30</td>\n",
       "      <td>[Biodiesel, Transesterification, Simulation, R...</td>\n",
       "      <td>Transesterification of vegetable oils: Simulat...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1020</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Ibanez, Delano Menecucci, Riccomini, Claudio,...</td>\n",
       "      <td>10.1016/j.geomorph.2014.02.019</td>\n",
       "      <td>2014-06-01</td>\n",
       "      <td>[Central Amazonia, Tectonics, Water loading, B...</td>\n",
       "      <td>Geomorphological evidence of recent tilting in...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1021</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Tessarolo, Nathalia S., Silva, Renzo C., Vani...</td>\n",
       "      <td>10.1016/j.microc.2014.06.006</td>\n",
       "      <td>2014-11-30</td>\n",
       "      <td>[Bio-oils, FT-ICR MS, GC×GC, TOFMS]</td>\n",
       "      <td>Assessing the chemical composition of bio-oils...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1022</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Magalhães, S.C., Scheid, C.M., Calçada, L.A.,...</td>\n",
       "      <td>10.1016/j.jngse.2016.02.001</td>\n",
       "      <td>2016-03-31</td>\n",
       "      <td>[Drilling fluids, Acoustic parameters, Hydraul...</td>\n",
       "      <td>Real time prediction of suspended solids in dr...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1023</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Terra, Luciana A., Filgueiras, Paulo R., Tose...</td>\n",
       "      <td>10.1016/j.fuel.2015.07.099</td>\n",
       "      <td>2015-11-15</td>\n",
       "      <td>[LDI, Petroleomics, CARSPLS, Crude oil, Basic ...</td>\n",
       "      <td>Laser desorption ionization FT-ICR mass spectr...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>972</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Muller, André Luís, do Amaral Vargas, Euríped...</td>\n",
       "      <td>10.1016/j.ijrmms.2008.05.001</td>\n",
       "      <td>2009-01-31</td>\n",
       "      <td>[Spatial variability, Fluid-mechanical couplin...</td>\n",
       "      <td>Borehole stability analysis considering spatia...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>973</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Sanches, I.D., Souza Filho, C.R., Magalhães, ...</td>\n",
       "      <td>10.1016/j.isprsjprs.2013.01.007</td>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>[Reflectance spectroscopy, Contamination, Liqu...</td>\n",
       "      <td>Assessing the impact of hydrocarbon leakages o...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>974</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Viviers, Marta Claudia, Koutsoukos, Eduardo A...</td>\n",
       "      <td>10.1006/cres.2000.0205</td>\n",
       "      <td>2000-04-30</td>\n",
       "      <td>[]</td>\n",
       "      <td>Stratigraphy and biogeographic affinities of t...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>975</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Loboziak, Stanislas, Caputo, Mário Vicente, M...</td>\n",
       "      <td>10.1016/S0035-1598(00)90154-5</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[Miospores, Biostratigraphy, Devonian, Tournai...</td>\n",
       "      <td>Middle Devonian-Tournaisian miospore biostrati...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>976</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Joly, Marcel, Pinto, José M.]</td>\n",
       "      <td>10.1016/j.mbs.2005.01.002</td>\n",
       "      <td>2005-05-31</td>\n",
       "      <td>[AIDS pathogenesis, Mathematical modeling, Che...</td>\n",
       "      <td>CXCR4 and CCR5 regulation and expression patte...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>977</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Santelli, Ricardo Erthal, Bezerra, Marcos Alm...</td>\n",
       "      <td>10.1016/j.fuel.2007.08.008</td>\n",
       "      <td>2008-07-31</td>\n",
       "      <td>[Petroleum derivatives, Emulsions, Non-volatil...</td>\n",
       "      <td>Non-volatile vanadium determination in petrole...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>978</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[de Moraes, F.D., Bastian, F.L., Ponciano, J.A.]</td>\n",
       "      <td>10.1016/j.corsci.2004.07.033</td>\n",
       "      <td>2005-06-30</td>\n",
       "      <td>[Steels, Hydrogen sulfide, Slow strain rate, E...</td>\n",
       "      <td>Influence of dynamic straining on hydrogen emb...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>979</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Carvalho, D.S., Joia, C.J.B., Mattos, O.R.]</td>\n",
       "      <td>10.1016/j.corsci.2005.05.052</td>\n",
       "      <td>2005-12-31</td>\n",
       "      <td>[CO2 corrosion, EIS, Acetate, NaCl, Iron and i...</td>\n",
       "      <td>Corrosion rate of iron and iron–chromium alloy...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Rocha, Anderson A, Miekeley, Norbert, Bezerra...</td>\n",
       "      <td>10.1016/j.microc.2004.03.012</td>\n",
       "      <td>2004-09-30</td>\n",
       "      <td>[ICP-MS, Phosphorus, Automation, Scale inhibit...</td>\n",
       "      <td>An automated system for preconcentration/matri...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>980</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Lovisi, Humberto, Tavares, Maria Inês B, da S...</td>\n",
       "      <td>10.1016/S0032-3861(01)00528-6</td>\n",
       "      <td>2001-11-30</td>\n",
       "      <td>[Metallocene catalysts, Propylene/1-hexene cop...</td>\n",
       "      <td>Influence of comonomer content and short branc...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>981</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Orge, M.D.R, Porsché, I.J, Costa, M.C, Lima, ...</td>\n",
       "      <td>10.1016/S1463-4988(00)00042-7</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[Effluents, Refinery, Polycyclic aromatic hydr...</td>\n",
       "      <td>Assessment of oil refinery waste on Rhizophora...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>982</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Chagas, L.H., De Carvalho, G.S.G., San Gil, R...</td>\n",
       "      <td>10.1016/j.materresbull.2013.08.072</td>\n",
       "      <td>2014-01-31</td>\n",
       "      <td>[A. Oxides, B. Chemical synthesis, C. X-ray di...</td>\n",
       "      <td>Obtaining aluminas from the thermal decomposit...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>983</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Mendonça Filho, J.G., Sommer, M.G., Klepzig, ...</td>\n",
       "      <td>10.1016/j.coal.2012.07.008</td>\n",
       "      <td>2013-05-01</td>\n",
       "      <td>[Carbonaceous shale, Palynofacies, Palynology,...</td>\n",
       "      <td>Permian carbonaceous rocks from the Bonito Coa...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>984</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[López Droguett, Enrique, das Chagas Moura, Má...</td>\n",
       "      <td>10.1016/j.simpat.2008.08.011</td>\n",
       "      <td>2008-11-30</td>\n",
       "      <td>[Semi-Markov process, Bayesian belief network,...</td>\n",
       "      <td>A semi-Markov model with Bayesian belief netwo...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>985</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Cerqueira, H.S., Caeiro, G., Costa, L., Ramôa...</td>\n",
       "      <td>10.1016/j.molcata.2008.06.014</td>\n",
       "      <td>2008-09-17</td>\n",
       "      <td>[FCC, Deactivation, Coke, Metals, Nitrogen com...</td>\n",
       "      <td>Deactivation of FCC catalysts</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>986</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Ferreira, Ary R., Martins, Mateus J.F., Konst...</td>\n",
       "      <td>10.1016/j.jssc.2011.03.016</td>\n",
       "      <td>2011-05-31</td>\n",
       "      <td>[\\n                     \\n                    ...</td>\n",
       "      <td>Direct comparison between two \\n              ...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>987</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Morgado, Edisson, de Abreu, Marco A.S., Pravi...</td>\n",
       "      <td>10.1016/j.solidstatesciences.2006.02.039</td>\n",
       "      <td>2006-08-31</td>\n",
       "      <td>[Sodium, Titanate, TiO2\\n                  , N...</td>\n",
       "      <td>A study on the structure and thermal stability...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>988</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Martins, Ricardo Rodrigues, Zouain, Nestor, B...</td>\n",
       "      <td>10.1016/j.euromechsol.2014.03.003</td>\n",
       "      <td>2014-10-31</td>\n",
       "      <td>[Shakedown, Limit analysis, Mixed shell element]</td>\n",
       "      <td>A continuum-based mixed shell element for shak...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>989</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Venancio, Igor M., Belem, Andre L., dos Santo...</td>\n",
       "      <td>10.1016/j.jmarsys.2014.06.009</td>\n",
       "      <td>2014-11-30</td>\n",
       "      <td>[Stable isotopes, Mixing processes, Water mass...</td>\n",
       "      <td>Influence of continental shelf processes in th...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Noronha, Dauro Braga, Martins, Ricardo Rodrig...</td>\n",
       "      <td>10.1016/j.ijpvp.2010.03.001</td>\n",
       "      <td>2010-05-31</td>\n",
       "      <td>[Pipelines, Dents, Strain-based assessment]</td>\n",
       "      <td>Procedures for the strain based assessment of ...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>990</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Cassella, Ricardo J., Brum, Daniel M., Lima, ...</td>\n",
       "      <td>10.1016/j.fuel.2010.12.008</td>\n",
       "      <td>2011-03-31</td>\n",
       "      <td>[Jet fuel, Electrothermal atomic absorption sp...</td>\n",
       "      <td>Direct determination of Cu and Fe in jet fuel ...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>991</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Duarte, Fábio A., Mello, Paola de A., Bizzi, ...</td>\n",
       "      <td>10.1016/j.fuel.2011.01.030</td>\n",
       "      <td>2011-06-30</td>\n",
       "      <td>[Desulfurization process, Ultrasound-assisted ...</td>\n",
       "      <td>Sulfur removal from hydrotreated petroleum fra...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>992</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Souza, Wladmir F., Pereira, Márcio C., A. Oli...</td>\n",
       "      <td>10.1016/j.fuel.2012.01.011</td>\n",
       "      <td>2012-06-30</td>\n",
       "      <td>[Magnetic iron oxide, Amphiphilic catalyst, Ox...</td>\n",
       "      <td>Amphiphilic catalysts based on onion-like carb...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Silva, Raphael S.F., Aguiar, Hélen G.M., Rang...</td>\n",
       "      <td>10.1016/j.fuel.2011.04.026</td>\n",
       "      <td>2011-08-31</td>\n",
       "      <td>[Biomarker analysis, GC×GC–TOFMS, Colombian oi...</td>\n",
       "      <td>Comprehensive two-dimensional gas chromatograp...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>994</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Martiniano, Lorena C., Abrantes, Vivia R., Ne...</td>\n",
       "      <td>10.1016/j.fuel.2012.07.002</td>\n",
       "      <td>2013-01-31</td>\n",
       "      <td>[Biodiesel microemulsion, Mercury film electro...</td>\n",
       "      <td>Direct simultaneous determination of Pb(II) an...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Harris, Robin K., Kowalewski, Jozef, Cabral d...</td>\n",
       "      <td>10.1016/S0926-2040(97)00079-9</td>\n",
       "      <td>1998-01-31</td>\n",
       "      <td>[IUPAC, NMR, Nucleus]</td>\n",
       "      <td>Parameters and symbols for use in nuclear magn...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Pinard, L., Bichon, P., Popov, A., Lemberton,...</td>\n",
       "      <td>10.1016/j.apcata.2011.08.012</td>\n",
       "      <td>2011-10-18</td>\n",
       "      <td>[Deactivation, Polymeric carbon, Atomic carbon...</td>\n",
       "      <td>Identification of the carbonaceous compounds p...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Quitete, Cristina P.B., Bittencourt, Roberto ...</td>\n",
       "      <td>10.1016/j.apcata.2014.04.019</td>\n",
       "      <td>2014-05-20</td>\n",
       "      <td>[Tar, Steam reforming, Nickel, Hexaaluminates]</td>\n",
       "      <td>Steam reforming of tar using toluene as a mode...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Faria, Rafael O., Kucharczak, Florentin, Frei...</td>\n",
       "      <td>10.1016/j.ifacol.2015.08.035</td>\n",
       "      <td>2015-12-31</td>\n",
       "      <td>[Autonomous Operation, Dual-Arm Robot, Visual ...</td>\n",
       "      <td>A Methodology for Autonomous Robotic Manipulat...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Ibanez, Delano Menecucci, de Miranda, Fernand...</td>\n",
       "      <td>10.1016/j.isprsjprs.2013.10.014</td>\n",
       "      <td>2014-01-31</td>\n",
       "      <td>[Amazon, SRTM, Geomorphometry, Fractal geometry]</td>\n",
       "      <td>Geomorphometric pattern recognition of SRTM da...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>1443 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               Abstract  \\\n",
       "0     \\n               Abstract\\n               \\n  ...   \n",
       "1                                                         \n",
       "10    \\n               Abstract\\n               \\n  ...   \n",
       "100   \\n               Abstract\\n               \\n  ...   \n",
       "1000  \\n               Abstract\\n               \\n  ...   \n",
       "1001  \\n               Abstract\\n               \\n  ...   \n",
       "1002  \\n               Abstract\\n               \\n  ...   \n",
       "1003  \\n               Abstract\\n               \\n  ...   \n",
       "1004  \\n               Abstract\\n               \\n  ...   \n",
       "1005  \\n               Abstract\\n               \\n  ...   \n",
       "1006  \\n               Abstract\\n               \\n  ...   \n",
       "1007  \\n               Abstract\\n               \\n  ...   \n",
       "1008  \\n               Abstract\\n               \\n  ...   \n",
       "1009  \\n               Abstract\\n               \\n  ...   \n",
       "101   \\n               Abstract\\n               \\n  ...   \n",
       "1010  \\n               Abstract\\n               \\n  ...   \n",
       "1011  \\n               Abstract\\n               \\n  ...   \n",
       "1012  \\n               Abstract\\n               \\n  ...   \n",
       "1013  \\n               Abstract\\n               \\n  ...   \n",
       "1014  \\n               Abstract\\n               \\n  ...   \n",
       "1015  \\n               Abstract\\n               \\n  ...   \n",
       "1016  \\n               Abstract\\n               \\n  ...   \n",
       "1017  \\n               Abstract\\n               \\n  ...   \n",
       "1018  \\n               Abstract\\n               \\n  ...   \n",
       "1019  \\n               Abstract\\n               \\n  ...   \n",
       "102   \\n               Abstract\\n               \\n  ...   \n",
       "1020  \\n               Abstract\\n               \\n  ...   \n",
       "1021  \\n               Abstract\\n               \\n  ...   \n",
       "1022  \\n               Abstract\\n               \\n  ...   \n",
       "1023  \\n               Abstract\\n               \\n  ...   \n",
       "...                                                 ...   \n",
       "972   \\n               Abstract\\n               \\n  ...   \n",
       "973   \\n               Abstract\\n               \\n  ...   \n",
       "974   \\n               Abstract\\n               \\n  ...   \n",
       "975   \\n               Abstract\\n               \\n  ...   \n",
       "976   \\n               Abstract\\n               \\n  ...   \n",
       "977   \\n               Abstract\\n               \\n  ...   \n",
       "978   \\n               Abstract\\n               \\n  ...   \n",
       "979   \\n               Abstract\\n               \\n  ...   \n",
       "98    \\n               Abstract\\n               \\n  ...   \n",
       "980   \\n               Abstract\\n               \\n  ...   \n",
       "981   \\n               Abstract\\n               \\n  ...   \n",
       "982   \\n               Abstract\\n               \\n  ...   \n",
       "983   \\n               Abstract\\n               \\n  ...   \n",
       "984   \\n               Abstract\\n               \\n  ...   \n",
       "985   \\n               Abstract\\n               \\n  ...   \n",
       "986   \\n               Abstract\\n               \\n  ...   \n",
       "987   \\n               Abstract\\n               \\n  ...   \n",
       "988   \\n               Abstract\\n               \\n  ...   \n",
       "989   \\n               Abstract\\n               \\n  ...   \n",
       "99    \\n               Abstract\\n               \\n  ...   \n",
       "990   \\n               Abstract\\n               \\n  ...   \n",
       "991   \\n               Abstract\\n               \\n  ...   \n",
       "992   \\n               Abstract\\n               \\n  ...   \n",
       "993   \\n               Abstract\\n               \\n  ...   \n",
       "994   \\n               Abstract\\n               \\n  ...   \n",
       "995   \\n               Abstract\\n               \\n  ...   \n",
       "996   \\n               Abstract\\n               \\n  ...   \n",
       "997   \\n               Abstract\\n               \\n  ...   \n",
       "998   \\n               Abstract\\n               \\n  ...   \n",
       "999   \\n               Abstract\\n               \\n  ...   \n",
       "\n",
       "                                                Creator  \\\n",
       "0     [Melo, Marcel, Schluter, Helga, Ferreira, Jail...   \n",
       "1     [Branco, Ricardo Castello, Baratelli, Fernando...   \n",
       "10    [Santos, Marcos Luiz Dos, Corrêa, Nelson Ferre...   \n",
       "100      [Lima, F.S.G., Araújo, M.A.S., Borges, L.E.P.]   \n",
       "1000  [Barros, Maria A.S.D., Silva, E.A., Arroyo, P....   \n",
       "1001  [Rojas, Marisol Fernández, Bernard, Franciele ...   \n",
       "1002  [Mosquera, Juan C., Ghisays, Alfredo, Montes, ...   \n",
       "1003  [Piovesan, Enelise Katia, Bergue, Cristianini ...   \n",
       "1004  [Quitete, Cristina P.B., Bittencourt, Roberto ...   \n",
       "1005  [Filgueiras, Paulo R., Sad, Cristina M.S., Lou...   \n",
       "1006  [Dalmaschio, Guilherme P., Malacarne, Majorie ...   \n",
       "1007  [Castro, Aline M., Castilho, Leda R., Freire, ...   \n",
       "1008  [Tannuri, Eduardo A., Silva, João Luis B., Ram...   \n",
       "1009  [Alves, Douglas Thiago S., de Medeiros, Jose L...   \n",
       "101   [Ferreira, Talles Souza, Araújo, Mario Neto Ca...   \n",
       "1010  [Minette, R.S., SilvaNeto, S.F., Vaz, L.A., Mo...   \n",
       "1011  [Passamonti, Francisco, de la Puente, Gabriela...   \n",
       "1012  [Calixto, Ewerton E.S., Pessoa, Fernando L.P.,...   \n",
       "1013  [Schmitt, William F., Szklo, Alexandre, Schaef...   \n",
       "1014  [dos Santos, Sidney Pereira, Eugenio Leal, Jos...   \n",
       "1015  [Melo, D.N.C., de Toledo, E.C. Vasco, Mariano,...   \n",
       "1016  [Dellagnezze, Bruna Martins, Vasconcellos, Suz...   \n",
       "1017  [Yamashita, André Shigueo, Alexandre, Paulo Ma...   \n",
       "1018  [de Paula Amaral do Valle, Pedro Wallace, Fort...   \n",
       "1019  [Menezes, Brenno C., Kelly, Jeffrey D., Grossm...   \n",
       "102   [Fonseca, Felipe A.S., Vidal-Vieira, José A., ...   \n",
       "1020  [Ibanez, Delano Menecucci, Riccomini, Claudio,...   \n",
       "1021  [Tessarolo, Nathalia S., Silva, Renzo C., Vani...   \n",
       "1022  [Magalhães, S.C., Scheid, C.M., Calçada, L.A.,...   \n",
       "1023  [Terra, Luciana A., Filgueiras, Paulo R., Tose...   \n",
       "...                                                 ...   \n",
       "972   [Muller, André Luís, do Amaral Vargas, Euríped...   \n",
       "973   [Sanches, I.D., Souza Filho, C.R., Magalhães, ...   \n",
       "974   [Viviers, Marta Claudia, Koutsoukos, Eduardo A...   \n",
       "975   [Loboziak, Stanislas, Caputo, Mário Vicente, M...   \n",
       "976                      [Joly, Marcel, Pinto, José M.]   \n",
       "977   [Santelli, Ricardo Erthal, Bezerra, Marcos Alm...   \n",
       "978    [de Moraes, F.D., Bastian, F.L., Ponciano, J.A.]   \n",
       "979        [Carvalho, D.S., Joia, C.J.B., Mattos, O.R.]   \n",
       "98    [Rocha, Anderson A, Miekeley, Norbert, Bezerra...   \n",
       "980   [Lovisi, Humberto, Tavares, Maria Inês B, da S...   \n",
       "981   [Orge, M.D.R, Porsché, I.J, Costa, M.C, Lima, ...   \n",
       "982   [Chagas, L.H., De Carvalho, G.S.G., San Gil, R...   \n",
       "983   [Mendonça Filho, J.G., Sommer, M.G., Klepzig, ...   \n",
       "984   [López Droguett, Enrique, das Chagas Moura, Má...   \n",
       "985   [Cerqueira, H.S., Caeiro, G., Costa, L., Ramôa...   \n",
       "986   [Ferreira, Ary R., Martins, Mateus J.F., Konst...   \n",
       "987   [Morgado, Edisson, de Abreu, Marco A.S., Pravi...   \n",
       "988   [Martins, Ricardo Rodrigues, Zouain, Nestor, B...   \n",
       "989   [Venancio, Igor M., Belem, Andre L., dos Santo...   \n",
       "99    [Noronha, Dauro Braga, Martins, Ricardo Rodrig...   \n",
       "990   [Cassella, Ricardo J., Brum, Daniel M., Lima, ...   \n",
       "991   [Duarte, Fábio A., Mello, Paola de A., Bizzi, ...   \n",
       "992   [Souza, Wladmir F., Pereira, Márcio C., A. Oli...   \n",
       "993   [Silva, Raphael S.F., Aguiar, Hélen G.M., Rang...   \n",
       "994   [Martiniano, Lorena C., Abrantes, Vivia R., Ne...   \n",
       "995   [Harris, Robin K., Kowalewski, Jozef, Cabral d...   \n",
       "996   [Pinard, L., Bichon, P., Popov, A., Lemberton,...   \n",
       "997   [Quitete, Cristina P.B., Bittencourt, Roberto ...   \n",
       "998   [Faria, Rafael O., Kucharczak, Florentin, Frei...   \n",
       "999   [Ibanez, Delano Menecucci, de Miranda, Fernand...   \n",
       "\n",
       "                                           DOI       Date  \\\n",
       "0                  10.1016/j.desal.2009.09.095 2010-01-30   \n",
       "1                10.1016/j.jbiotec.2008.07.942 2008-10-31   \n",
       "10                10.1016/0021-9797(74)90239-2 1974-06-30   \n",
       "100              10.1016/S0301-679X(03)00028-8 2003-09-30   \n",
       "1000                 10.1016/j.ces.2004.07.040 2004-12-31   \n",
       "1001             10.1016/j.molcata.2014.05.007 2014-10-31   \n",
       "1002             10.1016/S0016-7169(13)71475-2 2013-09-30   \n",
       "1003              10.1016/j.palaeo.2015.02.015 2015-04-15   \n",
       "1004              10.1016/j.catcom.2015.08.013 2015-11-05   \n",
       "1005                10.1016/j.fuel.2013.07.122 2014-01-15   \n",
       "1006                10.1016/j.fuel.2013.07.008 2014-01-31   \n",
       "1007                 10.1016/j.bej.2014.10.016 2015-01-15   \n",
       "1008          10.3182/20100915-3-DE-3008.00052 2010-09-30   \n",
       "1009                 10.1016/j.jlp.2016.03.026 2016-05-31   \n",
       "101            10.1016/j.marpetgeo.2014.02.012 2014-06-30   \n",
       "1010            10.1016/j.oceaneng.2016.07.054 2016-09-15   \n",
       "1011                 10.1016/j.cej.2011.12.081 2012-02-15   \n",
       "1012        10.1016/B978-0-444-63428-3.50337-4 2016-12-31   \n",
       "1013               10.1016/j.enpol.2011.02.067 2011-06-30   \n",
       "1014               10.1016/j.enpol.2011.06.047 2011-09-30   \n",
       "1015          10.3182/20070606-3-MX-2915.00110 2007-12-31   \n",
       "1016                 10.1016/j.bjm.2016.04.004 2016-09-30   \n",
       "1017          10.1016/j.conengprac.2016.02.003 2016-05-31   \n",
       "1018            10.1016/j.biombioe.2016.03.036 2016-08-31   \n",
       "1019         10.1016/j.compchemeng.2015.05.013 2015-09-02   \n",
       "102             10.1016/j.biortech.2010.05.077 2010-11-30   \n",
       "1020            10.1016/j.geomorph.2014.02.019 2014-06-01   \n",
       "1021              10.1016/j.microc.2014.06.006 2014-11-30   \n",
       "1022               10.1016/j.jngse.2016.02.001 2016-03-31   \n",
       "1023                10.1016/j.fuel.2015.07.099 2015-11-15   \n",
       "...                                        ...        ...   \n",
       "972               10.1016/j.ijrmms.2008.05.001 2009-01-31   \n",
       "973            10.1016/j.isprsjprs.2013.01.007 2013-04-30   \n",
       "974                     10.1006/cres.2000.0205 2000-04-30   \n",
       "975              10.1016/S0035-1598(00)90154-5 2000-12-31   \n",
       "976                  10.1016/j.mbs.2005.01.002 2005-05-31   \n",
       "977                 10.1016/j.fuel.2007.08.008 2008-07-31   \n",
       "978               10.1016/j.corsci.2004.07.033 2005-06-30   \n",
       "979               10.1016/j.corsci.2005.05.052 2005-12-31   \n",
       "98                10.1016/j.microc.2004.03.012 2004-09-30   \n",
       "980              10.1016/S0032-3861(01)00528-6 2001-11-30   \n",
       "981              10.1016/S1463-4988(00)00042-7 2000-12-31   \n",
       "982         10.1016/j.materresbull.2013.08.072 2014-01-31   \n",
       "983                 10.1016/j.coal.2012.07.008 2013-05-01   \n",
       "984               10.1016/j.simpat.2008.08.011 2008-11-30   \n",
       "985              10.1016/j.molcata.2008.06.014 2008-09-17   \n",
       "986                 10.1016/j.jssc.2011.03.016 2011-05-31   \n",
       "987   10.1016/j.solidstatesciences.2006.02.039 2006-08-31   \n",
       "988          10.1016/j.euromechsol.2014.03.003 2014-10-31   \n",
       "989              10.1016/j.jmarsys.2014.06.009 2014-11-30   \n",
       "99                 10.1016/j.ijpvp.2010.03.001 2010-05-31   \n",
       "990                 10.1016/j.fuel.2010.12.008 2011-03-31   \n",
       "991                 10.1016/j.fuel.2011.01.030 2011-06-30   \n",
       "992                 10.1016/j.fuel.2012.01.011 2012-06-30   \n",
       "993                 10.1016/j.fuel.2011.04.026 2011-08-31   \n",
       "994                 10.1016/j.fuel.2012.07.002 2013-01-31   \n",
       "995              10.1016/S0926-2040(97)00079-9 1998-01-31   \n",
       "996               10.1016/j.apcata.2011.08.012 2011-10-18   \n",
       "997               10.1016/j.apcata.2014.04.019 2014-05-20   \n",
       "998               10.1016/j.ifacol.2015.08.035 2015-12-31   \n",
       "999            10.1016/j.isprsjprs.2013.10.014 2014-01-31   \n",
       "\n",
       "                                               Keywords  \\\n",
       "0     [Reverse osmosis, Nanofiltration, Produced wat...   \n",
       "1                                                    []   \n",
       "10                                                   []   \n",
       "100   [Lubricant base oils, Carcinogenic potential, ...   \n",
       "1000  [Ion exchange, Zeolite, Modeling, Breakthrough...   \n",
       "1001  [CO2 utilization, Poly(ionic liquid)s, Ionomer...   \n",
       "1002  [caso histórico, modelado de pozo, tendencia d...   \n",
       "1003  [Palaeocology, Ostracods, Diversity, Sequence ...   \n",
       "1004  [Coking resistance, Nickel, Hexaaluminate, Tar...   \n",
       "1005  [Crude oil, ATR-FTIR, Partial least squares re...   \n",
       "1006  [Petroleomics, Distillation system, Mass spect...   \n",
       "1007  [Production of amylases, proteases, xylanases ...   \n",
       "1008  [Dynamic Positioning, Crane Barge, Hydrodynami...   \n",
       "1009  [Risk to general public, Major accident hazard...   \n",
       "101   [Cumuruxatiba basin, Contractional Cenozoic sa...   \n",
       "1010  [Output-only modal analysis, Integration tests...   \n",
       "1011  [FCC, Catalyst evaluation, FFB, CREC Riser Sim...   \n",
       "1012  [H2S Scavenger, H2S Scavenger Software, Crude ...   \n",
       "1013  [Vehicle efficiency, GHG emissions, Land use c...   \n",
       "1014  [Natural gas industry, Investment analysis, Pl...   \n",
       "1015  [optimization, two-layer approach, genetic alg...   \n",
       "1016  [Bacterial diversity, Microbial enrichment, Pe...   \n",
       "1017  [Model predictive controller tuning, Reference...   \n",
       "1018  [Doehlert design, Hydrated ethanol, Phase evol...   \n",
       "1019  [Oil-refinery production, Investment planning,...   \n",
       "102   [Biodiesel, Transesterification, Simulation, R...   \n",
       "1020  [Central Amazonia, Tectonics, Water loading, B...   \n",
       "1021                [Bio-oils, FT-ICR MS, GC×GC, TOFMS]   \n",
       "1022  [Drilling fluids, Acoustic parameters, Hydraul...   \n",
       "1023  [LDI, Petroleomics, CARSPLS, Crude oil, Basic ...   \n",
       "...                                                 ...   \n",
       "972   [Spatial variability, Fluid-mechanical couplin...   \n",
       "973   [Reflectance spectroscopy, Contamination, Liqu...   \n",
       "974                                                  []   \n",
       "975   [Miospores, Biostratigraphy, Devonian, Tournai...   \n",
       "976   [AIDS pathogenesis, Mathematical modeling, Che...   \n",
       "977   [Petroleum derivatives, Emulsions, Non-volatil...   \n",
       "978   [Steels, Hydrogen sulfide, Slow strain rate, E...   \n",
       "979   [CO2 corrosion, EIS, Acetate, NaCl, Iron and i...   \n",
       "98    [ICP-MS, Phosphorus, Automation, Scale inhibit...   \n",
       "980   [Metallocene catalysts, Propylene/1-hexene cop...   \n",
       "981   [Effluents, Refinery, Polycyclic aromatic hydr...   \n",
       "982   [A. Oxides, B. Chemical synthesis, C. X-ray di...   \n",
       "983   [Carbonaceous shale, Palynofacies, Palynology,...   \n",
       "984   [Semi-Markov process, Bayesian belief network,...   \n",
       "985   [FCC, Deactivation, Coke, Metals, Nitrogen com...   \n",
       "986   [\\n                     \\n                    ...   \n",
       "987   [Sodium, Titanate, TiO2\\n                  , N...   \n",
       "988    [Shakedown, Limit analysis, Mixed shell element]   \n",
       "989   [Stable isotopes, Mixing processes, Water mass...   \n",
       "99          [Pipelines, Dents, Strain-based assessment]   \n",
       "990   [Jet fuel, Electrothermal atomic absorption sp...   \n",
       "991   [Desulfurization process, Ultrasound-assisted ...   \n",
       "992   [Magnetic iron oxide, Amphiphilic catalyst, Ox...   \n",
       "993   [Biomarker analysis, GC×GC–TOFMS, Colombian oi...   \n",
       "994   [Biodiesel microemulsion, Mercury film electro...   \n",
       "995                               [IUPAC, NMR, Nucleus]   \n",
       "996   [Deactivation, Polymeric carbon, Atomic carbon...   \n",
       "997      [Tar, Steam reforming, Nickel, Hexaaluminates]   \n",
       "998   [Autonomous Operation, Dual-Arm Robot, Visual ...   \n",
       "999    [Amazon, SRTM, Geomorphometry, Fractal geometry]   \n",
       "\n",
       "                                                  Title  O&G  Affiliate  \n",
       "0     Advanced performance evaluation of a reverse o...    1  Petrobras  \n",
       "1                  Petrobras’ developments in biofuels     1  Petrobras  \n",
       "10    Interaction of polyethylene with isobutane, is...    1  Petrobras  \n",
       "100   Determination of the carcinogenic potential of...    1  Petrobras  \n",
       "1000  Removal of Cr(III) in the fixed bed column and...    1  Petrobras  \n",
       "1001  Poly(ionic liquid)s as efficient catalyst in t...    1  Petrobras  \n",
       "1002  AVO analysis with partial stacking to detect g...    1  Petrobras  \n",
       "1003  Palaeoecology of ostracods from the Late Creta...    1  Petrobras  \n",
       "1004  Coking resistance evaluation of tar removal ca...    1  Petrobras  \n",
       "1005  Determination of API gravity, kinematic viscos...    1  Petrobras  \n",
       "1006  Characterization of polar compounds in a true ...    1  Petrobras  \n",
       "1007  Performance of a fixed-bed solid-state ferment...    1  Petrobras  \n",
       "1008  Methodology for evaluating DP crane-barge oper...    1  Petrobras  \n",
       "1009  Optimal determination of chemical plant layout...    1  Petrobras  \n",
       "101   Cenozoic folding in the Cumuruxatiba basin, Br...    1  Petrobras  \n",
       "1010  Experimental modal analysis of electrical subm...    1  Petrobras  \n",
       "1011  Comparison between fixed fluidized bed (FFB) a...    1  Petrobras  \n",
       "1012  A New Technology to Optimize the Use of H2S Sc...    1  Petrobras  \n",
       "1013  Policies for improving the efficiency of the B...    1  Petrobras  \n",
       "1014  The development of a natural gas transportatio...    1  Petrobras  \n",
       "1015  AN APPROACH TO OPTIMIZATION OF A THREE PHASE C...    1  Petrobras  \n",
       "1016  Evaluation of bacterial diversity recovered fr...    1  Petrobras  \n",
       "1017  Reference trajectory tuning of model predictiv...    1  Petrobras  \n",
       "1018  A systematic multivariate analysis of the supe...    1  Petrobras  \n",
       "1019  Generalized capital investment planning of oil...    1  Petrobras  \n",
       "102   Transesterification of vegetable oils: Simulat...    1  Petrobras  \n",
       "1020  Geomorphological evidence of recent tilting in...    1  Petrobras  \n",
       "1021  Assessing the chemical composition of bio-oils...    1  Petrobras  \n",
       "1022  Real time prediction of suspended solids in dr...    1  Petrobras  \n",
       "1023  Laser desorption ionization FT-ICR mass spectr...    1  Petrobras  \n",
       "...                                                 ...  ...        ...  \n",
       "972   Borehole stability analysis considering spatia...    1  Petrobras  \n",
       "973   Assessing the impact of hydrocarbon leakages o...    1  Petrobras  \n",
       "974   Stratigraphy and biogeographic affinities of t...    1  Petrobras  \n",
       "975   Middle Devonian-Tournaisian miospore biostrati...    1  Petrobras  \n",
       "976   CXCR4 and CCR5 regulation and expression patte...    1  Petrobras  \n",
       "977   Non-volatile vanadium determination in petrole...    1  Petrobras  \n",
       "978   Influence of dynamic straining on hydrogen emb...    1  Petrobras  \n",
       "979   Corrosion rate of iron and iron–chromium alloy...    1  Petrobras  \n",
       "98    An automated system for preconcentration/matri...    1  Petrobras  \n",
       "980   Influence of comonomer content and short branc...    1  Petrobras  \n",
       "981   Assessment of oil refinery waste on Rhizophora...    1  Petrobras  \n",
       "982   Obtaining aluminas from the thermal decomposit...    1  Petrobras  \n",
       "983   Permian carbonaceous rocks from the Bonito Coa...    1  Petrobras  \n",
       "984   A semi-Markov model with Bayesian belief netwo...    1  Petrobras  \n",
       "985                      Deactivation of FCC catalysts     1  Petrobras  \n",
       "986   Direct comparison between two \\n              ...    1  Petrobras  \n",
       "987   A study on the structure and thermal stability...    1  Petrobras  \n",
       "988   A continuum-based mixed shell element for shak...    1  Petrobras  \n",
       "989   Influence of continental shelf processes in th...    1  Petrobras  \n",
       "99    Procedures for the strain based assessment of ...    1  Petrobras  \n",
       "990   Direct determination of Cu and Fe in jet fuel ...    1  Petrobras  \n",
       "991   Sulfur removal from hydrotreated petroleum fra...    1  Petrobras  \n",
       "992   Amphiphilic catalysts based on onion-like carb...    1  Petrobras  \n",
       "993   Comprehensive two-dimensional gas chromatograp...    1  Petrobras  \n",
       "994   Direct simultaneous determination of Pb(II) an...    1  Petrobras  \n",
       "995   Parameters and symbols for use in nuclear magn...    1  Petrobras  \n",
       "996   Identification of the carbonaceous compounds p...    1  Petrobras  \n",
       "997   Steam reforming of tar using toluene as a mode...    1  Petrobras  \n",
       "998   A Methodology for Autonomous Robotic Manipulat...    1  Petrobras  \n",
       "999   Geomorphometric pattern recognition of SRTM da...    1  Petrobras  \n",
       "\n",
       "[1443 rows x 8 columns]"
      ]
     },
     "execution_count": 32,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Inicialmete lemos o arquivo referente aos textos da \"Petrobras\"\n",
    "abstract_petrobras = pd.read_json(path_or_buf=\"Elsevier_abstracts - Petrobras.json\")\n",
    "abstract_petrobras['O&G'] = 1\n",
    "abstract_petrobras['Affiliate'] = 'Petrobras'\n",
    "abstract_petrobras"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 33,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Abstract</th>\n",
       "      <th>Creator</th>\n",
       "      <th>DOI</th>\n",
       "      <th>Date</th>\n",
       "      <th>Keywords</th>\n",
       "      <th>Title</th>\n",
       "      <th>O&amp;G</th>\n",
       "      <th>Affiliate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Melo, Marcel, Schluter, Helga, Ferreira, Jail...</td>\n",
       "      <td>10.1016/j.desal.2009.09.095</td>\n",
       "      <td>2010-01-30</td>\n",
       "      <td>[Reverse osmosis, Nanofiltration, Produced wat...</td>\n",
       "      <td>Advanced performance evaluation of a reverse o...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td></td>\n",
       "      <td>[Branco, Ricardo Castello, Baratelli, Fernando...</td>\n",
       "      <td>10.1016/j.jbiotec.2008.07.942</td>\n",
       "      <td>2008-10-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>Petrobras’ developments in biofuels</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Santos, Marcos Luiz Dos, Corrêa, Nelson Ferre...</td>\n",
       "      <td>10.1016/0021-9797(74)90239-2</td>\n",
       "      <td>1974-06-30</td>\n",
       "      <td>[]</td>\n",
       "      <td>Interaction of polyethylene with isobutane, is...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>100</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Lima, F.S.G., Araújo, M.A.S., Borges, L.E.P.]</td>\n",
       "      <td>10.1016/S0301-679X(03)00028-8</td>\n",
       "      <td>2003-09-30</td>\n",
       "      <td>[Lubricant base oils, Carcinogenic potential, ...</td>\n",
       "      <td>Determination of the carcinogenic potential of...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1000</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Barros, Maria A.S.D., Silva, E.A., Arroyo, P....</td>\n",
       "      <td>10.1016/j.ces.2004.07.040</td>\n",
       "      <td>2004-12-31</td>\n",
       "      <td>[Ion exchange, Zeolite, Modeling, Breakthrough...</td>\n",
       "      <td>Removal of Cr(III) in the fixed bed column and...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1001</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Rojas, Marisol Fernández, Bernard, Franciele ...</td>\n",
       "      <td>10.1016/j.molcata.2014.05.007</td>\n",
       "      <td>2014-10-31</td>\n",
       "      <td>[CO2 utilization, Poly(ionic liquid)s, Ionomer...</td>\n",
       "      <td>Poly(ionic liquid)s as efficient catalyst in t...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1002</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Mosquera, Juan C., Ghisays, Alfredo, Montes, ...</td>\n",
       "      <td>10.1016/S0016-7169(13)71475-2</td>\n",
       "      <td>2013-09-30</td>\n",
       "      <td>[caso histórico, modelado de pozo, tendencia d...</td>\n",
       "      <td>AVO analysis with partial stacking to detect g...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1003</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Piovesan, Enelise Katia, Bergue, Cristianini ...</td>\n",
       "      <td>10.1016/j.palaeo.2015.02.015</td>\n",
       "      <td>2015-04-15</td>\n",
       "      <td>[Palaeocology, Ostracods, Diversity, Sequence ...</td>\n",
       "      <td>Palaeoecology of ostracods from the Late Creta...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1004</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Quitete, Cristina P.B., Bittencourt, Roberto ...</td>\n",
       "      <td>10.1016/j.catcom.2015.08.013</td>\n",
       "      <td>2015-11-05</td>\n",
       "      <td>[Coking resistance, Nickel, Hexaaluminate, Tar...</td>\n",
       "      <td>Coking resistance evaluation of tar removal ca...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1005</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Filgueiras, Paulo R., Sad, Cristina M.S., Lou...</td>\n",
       "      <td>10.1016/j.fuel.2013.07.122</td>\n",
       "      <td>2014-01-15</td>\n",
       "      <td>[Crude oil, ATR-FTIR, Partial least squares re...</td>\n",
       "      <td>Determination of API gravity, kinematic viscos...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1006</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Dalmaschio, Guilherme P., Malacarne, Majorie ...</td>\n",
       "      <td>10.1016/j.fuel.2013.07.008</td>\n",
       "      <td>2014-01-31</td>\n",
       "      <td>[Petroleomics, Distillation system, Mass spect...</td>\n",
       "      <td>Characterization of polar compounds in a true ...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1007</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Castro, Aline M., Castilho, Leda R., Freire, ...</td>\n",
       "      <td>10.1016/j.bej.2014.10.016</td>\n",
       "      <td>2015-01-15</td>\n",
       "      <td>[Production of amylases, proteases, xylanases ...</td>\n",
       "      <td>Performance of a fixed-bed solid-state ferment...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1008</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Tannuri, Eduardo A., Silva, João Luis B., Ram...</td>\n",
       "      <td>10.3182/20100915-3-DE-3008.00052</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>[Dynamic Positioning, Crane Barge, Hydrodynami...</td>\n",
       "      <td>Methodology for evaluating DP crane-barge oper...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1009</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Alves, Douglas Thiago S., de Medeiros, Jose L...</td>\n",
       "      <td>10.1016/j.jlp.2016.03.026</td>\n",
       "      <td>2016-05-31</td>\n",
       "      <td>[Risk to general public, Major accident hazard...</td>\n",
       "      <td>Optimal determination of chemical plant layout...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>101</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Ferreira, Talles Souza, Araújo, Mario Neto Ca...</td>\n",
       "      <td>10.1016/j.marpetgeo.2014.02.012</td>\n",
       "      <td>2014-06-30</td>\n",
       "      <td>[Cumuruxatiba basin, Contractional Cenozoic sa...</td>\n",
       "      <td>Cenozoic folding in the Cumuruxatiba basin, Br...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1010</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Minette, R.S., SilvaNeto, S.F., Vaz, L.A., Mo...</td>\n",
       "      <td>10.1016/j.oceaneng.2016.07.054</td>\n",
       "      <td>2016-09-15</td>\n",
       "      <td>[Output-only modal analysis, Integration tests...</td>\n",
       "      <td>Experimental modal analysis of electrical subm...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1011</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Passamonti, Francisco, de la Puente, Gabriela...</td>\n",
       "      <td>10.1016/j.cej.2011.12.081</td>\n",
       "      <td>2012-02-15</td>\n",
       "      <td>[FCC, Catalyst evaluation, FFB, CREC Riser Sim...</td>\n",
       "      <td>Comparison between fixed fluidized bed (FFB) a...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1012</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Calixto, Ewerton E.S., Pessoa, Fernando L.P.,...</td>\n",
       "      <td>10.1016/B978-0-444-63428-3.50337-4</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>[H2S Scavenger, H2S Scavenger Software, Crude ...</td>\n",
       "      <td>A New Technology to Optimize the Use of H2S Sc...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1013</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Schmitt, William F., Szklo, Alexandre, Schaef...</td>\n",
       "      <td>10.1016/j.enpol.2011.02.067</td>\n",
       "      <td>2011-06-30</td>\n",
       "      <td>[Vehicle efficiency, GHG emissions, Land use c...</td>\n",
       "      <td>Policies for improving the efficiency of the B...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1014</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[dos Santos, Sidney Pereira, Eugenio Leal, Jos...</td>\n",
       "      <td>10.1016/j.enpol.2011.06.047</td>\n",
       "      <td>2011-09-30</td>\n",
       "      <td>[Natural gas industry, Investment analysis, Pl...</td>\n",
       "      <td>The development of a natural gas transportatio...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1015</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Melo, D.N.C., de Toledo, E.C. Vasco, Mariano,...</td>\n",
       "      <td>10.3182/20070606-3-MX-2915.00110</td>\n",
       "      <td>2007-12-31</td>\n",
       "      <td>[optimization, two-layer approach, genetic alg...</td>\n",
       "      <td>AN APPROACH TO OPTIMIZATION OF A THREE PHASE C...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1016</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Dellagnezze, Bruna Martins, Vasconcellos, Suz...</td>\n",
       "      <td>10.1016/j.bjm.2016.04.004</td>\n",
       "      <td>2016-09-30</td>\n",
       "      <td>[Bacterial diversity, Microbial enrichment, Pe...</td>\n",
       "      <td>Evaluation of bacterial diversity recovered fr...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1017</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Yamashita, André Shigueo, Alexandre, Paulo Ma...</td>\n",
       "      <td>10.1016/j.conengprac.2016.02.003</td>\n",
       "      <td>2016-05-31</td>\n",
       "      <td>[Model predictive controller tuning, Reference...</td>\n",
       "      <td>Reference trajectory tuning of model predictiv...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1018</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[de Paula Amaral do Valle, Pedro Wallace, Fort...</td>\n",
       "      <td>10.1016/j.biombioe.2016.03.036</td>\n",
       "      <td>2016-08-31</td>\n",
       "      <td>[Doehlert design, Hydrated ethanol, Phase evol...</td>\n",
       "      <td>A systematic multivariate analysis of the supe...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1019</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Menezes, Brenno C., Kelly, Jeffrey D., Grossm...</td>\n",
       "      <td>10.1016/j.compchemeng.2015.05.013</td>\n",
       "      <td>2015-09-02</td>\n",
       "      <td>[Oil-refinery production, Investment planning,...</td>\n",
       "      <td>Generalized capital investment planning of oil...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>102</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Fonseca, Felipe A.S., Vidal-Vieira, José A., ...</td>\n",
       "      <td>10.1016/j.biortech.2010.05.077</td>\n",
       "      <td>2010-11-30</td>\n",
       "      <td>[Biodiesel, Transesterification, Simulation, R...</td>\n",
       "      <td>Transesterification of vegetable oils: Simulat...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1020</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Ibanez, Delano Menecucci, Riccomini, Claudio,...</td>\n",
       "      <td>10.1016/j.geomorph.2014.02.019</td>\n",
       "      <td>2014-06-01</td>\n",
       "      <td>[Central Amazonia, Tectonics, Water loading, B...</td>\n",
       "      <td>Geomorphological evidence of recent tilting in...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1021</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Tessarolo, Nathalia S., Silva, Renzo C., Vani...</td>\n",
       "      <td>10.1016/j.microc.2014.06.006</td>\n",
       "      <td>2014-11-30</td>\n",
       "      <td>[Bio-oils, FT-ICR MS, GC×GC, TOFMS]</td>\n",
       "      <td>Assessing the chemical composition of bio-oils...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1022</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Magalhães, S.C., Scheid, C.M., Calçada, L.A.,...</td>\n",
       "      <td>10.1016/j.jngse.2016.02.001</td>\n",
       "      <td>2016-03-31</td>\n",
       "      <td>[Drilling fluids, Acoustic parameters, Hydraul...</td>\n",
       "      <td>Real time prediction of suspended solids in dr...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1023</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Terra, Luciana A., Filgueiras, Paulo R., Tose...</td>\n",
       "      <td>10.1016/j.fuel.2015.07.099</td>\n",
       "      <td>2015-11-15</td>\n",
       "      <td>[LDI, Petroleomics, CARSPLS, Crude oil, Basic ...</td>\n",
       "      <td>Laser desorption ionization FT-ICR mass spectr...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>972</th>\n",
       "      <td></td>\n",
       "      <td>[Abou Anoma, G., Fuks, J.-J., Sainsaulieu, F.,...</td>\n",
       "      <td>10.1016/j.admp.2012.03.433</td>\n",
       "      <td>2012-06-30</td>\n",
       "      <td>[]</td>\n",
       "      <td>Évaluation de l’exposition au benzène d’une co...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>973</th>\n",
       "      <td>\\n               Résumé\\n               \\n    ...</td>\n",
       "      <td>[Bensefa-Colas, L., Pineau, F., Hadengue, P., ...</td>\n",
       "      <td>10.1016/j.admp.2009.02.012</td>\n",
       "      <td>2009-04-30</td>\n",
       "      <td>[Benzène, Acide trans,trans-muconique, Citerni...</td>\n",
       "      <td>Exposition professionnelle au benzène dans le ...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>974</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Fleury, Jean-Marc, Pubellier, Manuel, de Urre...</td>\n",
       "      <td>10.1016/j.lithos.2009.07.007</td>\n",
       "      <td>2009-11-30</td>\n",
       "      <td>[Subduction blocking, Subduction jump, Asperit...</td>\n",
       "      <td>Structural expression of forearc crust uplift ...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>975</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Galliéro, Guillaume, Boned, Christian, Baylau...</td>\n",
       "      <td>10.1016/j.chemphys.2007.02.002</td>\n",
       "      <td>2007-03-30</td>\n",
       "      <td>[Molecular dynamics, Mie and exponential poten...</td>\n",
       "      <td>Influence of the repulsive coefficient α and a...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>976</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Garrigues, P., De Vazelhes-De Sury, R., Angel...</td>\n",
       "      <td>10.1016/0146-6380(84)90105-0</td>\n",
       "      <td>1984-12-31</td>\n",
       "      <td>[methyl-PAH, Shpol'skii-luminescence, maturity...</td>\n",
       "      <td>Analysis of series of aromatic isomers by high...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>977</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Boukhicha, Rym, Charpentier, Coralie, Prod'Ho...</td>\n",
       "      <td>10.1016/j.tsf.2013.08.014</td>\n",
       "      <td>2014-03-31</td>\n",
       "      <td>[Transparent conductive oxide, Laser annealing...</td>\n",
       "      <td>Influence of sputtering conditions on the opti...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>978</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Dibenedetto, Angela, Angelini, Antonella, Fas...</td>\n",
       "      <td>10.1016/j.jcou.2014.10.002</td>\n",
       "      <td>2014-12-31</td>\n",
       "      <td>[Alcoholysis of urea, Diethylcarbonate, Interm...</td>\n",
       "      <td>The reaction mechanism in the ethanolysis of u...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>979</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Hatcher, Patrick G., Ravin, Azdine, Behar, Fr...</td>\n",
       "      <td>10.1016/j.orggeochem.2014.05.016</td>\n",
       "      <td>2014-10-31</td>\n",
       "      <td>[Early diagenesis, Sedimentary organic matter,...</td>\n",
       "      <td>Diagenesis of organic matter in a 400 m organi...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>98</th>\n",
       "      <td></td>\n",
       "      <td>[Ninomiya, N., Obayashi, M., Nakamura, R., Sek...</td>\n",
       "      <td>10.1016/j.jsxm.2018.03.068</td>\n",
       "      <td>2018-06-30</td>\n",
       "      <td>[]</td>\n",
       "      <td>077 On the Initial Treatment Experience of CO2...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>980</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Cazenave, J., Seguela, R., Sixou, B., Germain...</td>\n",
       "      <td>10.1016/j.polymer.2006.03.094</td>\n",
       "      <td>2006-05-17</td>\n",
       "      <td>[Polyethylene, Molecular architecture, Stress ...</td>\n",
       "      <td>Short-term mechanical and structural approache...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>981</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Parize, Olivier, Mulder, Thierry, Cahuzac, Br...</td>\n",
       "      <td>10.1016/j.crte.2008.03.004</td>\n",
       "      <td>2008-06-30</td>\n",
       "      <td>[Stratotypes, Aquitanian, Burdigalian, Sedimen...</td>\n",
       "      <td>Sedimentology and sequence stratigraphy of Aqu...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>982</th>\n",
       "      <td>\\n            Abstract\\n            \\n        ...</td>\n",
       "      <td>[Salzano, Ernesto, Hoorelbeke, Pol, Khan, Fais...</td>\n",
       "      <td>10.1016/B978-0-444-54323-3.00004-X</td>\n",
       "      <td>2013-12-31</td>\n",
       "      <td>[Blast load, Domino effect, Explosion, Loss of...</td>\n",
       "      <td>4 Overpressure Effects</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>983</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Mańko, Maria, Chal, Robin, Trens, Philippe, M...</td>\n",
       "      <td>10.1016/j.micromeso.2012.12.016</td>\n",
       "      <td>2013-04-30</td>\n",
       "      <td>[Quasi-equilibrated thermodesorption, Hierarch...</td>\n",
       "      <td>Porosity of micro–mesoporous zeolites prepared...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>984</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Blanc, Ph., Lassin, A., Piantone, P., Azaroua...</td>\n",
       "      <td>10.1016/j.apgeochem.2012.06.002</td>\n",
       "      <td>2012-10-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>Thermoddem: A geochemical database focused on ...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>985</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Jacquemet, Nicolas, Pironon, Jacques, Lagneau...</td>\n",
       "      <td>10.1016/j.apgeochem.2011.12.004</td>\n",
       "      <td>2012-03-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>Armouring of well cement in H2S–CO2 saturated ...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>986</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[DeKoninck, Philip, Gratacos, Eduardo, Van Mie...</td>\n",
       "      <td>10.1016/j.earlhumdev.2011.08.001</td>\n",
       "      <td>2011-09-30</td>\n",
       "      <td>[Congenital diaphragmatic hernia, Fetal interv...</td>\n",
       "      <td>Results of Fetal Endoscopic Tracheal Occlusion...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>987</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Faulkner, D.R., Jackson, C.A.L., Lunn, R.J., ...</td>\n",
       "      <td>10.1016/j.jsg.2010.06.009</td>\n",
       "      <td>2010-11-30</td>\n",
       "      <td>[Faults, Structure, Fluid flow, Mechanics, Ear...</td>\n",
       "      <td>A review of recent developments concerning the...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>988</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Jabbour, Majed, Dhont, Damien, Hervouët, Yves...</td>\n",
       "      <td>10.1016/j.jsg.2012.05.002</td>\n",
       "      <td>2012-09-30</td>\n",
       "      <td>[Fault-propagation fold, Variable interlimb an...</td>\n",
       "      <td>Geometry and kinematics of fault-propagation f...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>989</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Al-Huwayrini, Lujain, Al-Furiji, Samah, Al-Dh...</td>\n",
       "      <td>10.1016/j.sdentj.2013.05.001</td>\n",
       "      <td>2013-07-31</td>\n",
       "      <td>[Dentists, Antibiotics’ knowledge, Antibiotics...</td>\n",
       "      <td>Knowledge of antibiotics among dentists in Riy...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>99</th>\n",
       "      <td></td>\n",
       "      <td>[Coudreuse, L., Cadilhac, B., Dumontier, C., K...</td>\n",
       "      <td>10.1533/9781845693244.100</td>\n",
       "      <td>2007-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>10 Disbonding test methodology: Definition of ...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>990</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Alaoui, F., Montero, E., Bazile, J.P., Comuña...</td>\n",
       "      <td>10.1016/j.fluid.2012.02.007</td>\n",
       "      <td>2012-04-25</td>\n",
       "      <td>[1-Hexanol, Density, High pressure, Isobaric t...</td>\n",
       "      <td>Liquid density of oxygenated additives to bio-...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>991</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Zhang, Huilong, Innal, Fares, Dufour, Françoi...</td>\n",
       "      <td>10.1016/j.ress.2014.01.016</td>\n",
       "      <td>2014-06-30</td>\n",
       "      <td>[Dynamic reliability, Piecewise Deterministic ...</td>\n",
       "      <td>Piecewise Deterministic Markov Processes based...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>992</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Reijmer, J.J.G., Mulder, T., Borgomano, J.]</td>\n",
       "      <td>10.1016/j.sedgeo.2014.12.001</td>\n",
       "      <td>2015-03-15</td>\n",
       "      <td>[Carbonate slopes, Gravity deposits, Sedimenta...</td>\n",
       "      <td>Carbonate slopes and gravity deposits</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>993</th>\n",
       "      <td>\\n               \\n                  Backgroun...</td>\n",
       "      <td>[Jung, Yoon Suk, Ryu, Seungho, Chang, Yoosoo, ...</td>\n",
       "      <td>10.1016/j.gie.2014.09.031</td>\n",
       "      <td>2015-03-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>Risk factors for colorectal neoplasia in perso...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>994</th>\n",
       "      <td></td>\n",
       "      <td>[Thierfelder, Christian, Chisui, John L., Gama...</td>\n",
       "      <td>10.1016/j.fcr.2013.01.004</td>\n",
       "      <td>2013-02-20</td>\n",
       "      <td>[]</td>\n",
       "      <td>Corrigendum to: Maize-based conservation agric...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>995</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Stricot, M., Filali, A., Lesage, N., Spérandi...</td>\n",
       "      <td>10.1016/j.watres.2009.12.021</td>\n",
       "      <td>2010-04-30</td>\n",
       "      <td>[Membrane bioreactor, Side-stream configuratio...</td>\n",
       "      <td>Side-stream membrane bioreactors: Influence of...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>996</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Thierfelder, Christian, Chisui, John L., Gama...</td>\n",
       "      <td>10.1016/j.fcr.2012.11.010</td>\n",
       "      <td>2013-02-20</td>\n",
       "      <td>[Sustainability, No-tillage, Direct seeding, R...</td>\n",
       "      <td>Maize-based conservation agriculture systems i...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>997</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Eissa, Yehia, Munawwar, Saima, Oumbe, Armel, ...</td>\n",
       "      <td>10.1016/j.solener.2015.01.017</td>\n",
       "      <td>2015-04-30</td>\n",
       "      <td>[Aerosols, Atmosphere, MACC, Solar radiation]</td>\n",
       "      <td>Validating surface downwelling solar irradianc...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>998</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Cézac, Pierre, Serin, Jean-Paul, Reneaume, Je...</td>\n",
       "      <td>10.1016/j.supflu.2007.11.005</td>\n",
       "      <td>2008-03-31</td>\n",
       "      <td>[Modelling, Solid–gas equilibrium, Natural gas...</td>\n",
       "      <td>Elemental sulphur deposition in natural gas tr...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>999</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Donot, F., Cazals, G., Gunata, Z., Egron, D.,...</td>\n",
       "      <td>10.1016/j.jchromb.2013.10.016</td>\n",
       "      <td>2013-12-30</td>\n",
       "      <td>[Neutral lipids, Microalgae, HPLC, ELSD, APCI-...</td>\n",
       "      <td>Analysis of neutral lipids from microalgae by ...</td>\n",
       "      <td>1</td>\n",
       "      <td>Total</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>16349 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                               Abstract  \\\n",
       "0     \\n               Abstract\\n               \\n  ...   \n",
       "1                                                         \n",
       "10    \\n               Abstract\\n               \\n  ...   \n",
       "100   \\n               Abstract\\n               \\n  ...   \n",
       "1000  \\n               Abstract\\n               \\n  ...   \n",
       "1001  \\n               Abstract\\n               \\n  ...   \n",
       "1002  \\n               Abstract\\n               \\n  ...   \n",
       "1003  \\n               Abstract\\n               \\n  ...   \n",
       "1004  \\n               Abstract\\n               \\n  ...   \n",
       "1005  \\n               Abstract\\n               \\n  ...   \n",
       "1006  \\n               Abstract\\n               \\n  ...   \n",
       "1007  \\n               Abstract\\n               \\n  ...   \n",
       "1008  \\n               Abstract\\n               \\n  ...   \n",
       "1009  \\n               Abstract\\n               \\n  ...   \n",
       "101   \\n               Abstract\\n               \\n  ...   \n",
       "1010  \\n               Abstract\\n               \\n  ...   \n",
       "1011  \\n               Abstract\\n               \\n  ...   \n",
       "1012  \\n               Abstract\\n               \\n  ...   \n",
       "1013  \\n               Abstract\\n               \\n  ...   \n",
       "1014  \\n               Abstract\\n               \\n  ...   \n",
       "1015  \\n               Abstract\\n               \\n  ...   \n",
       "1016  \\n               Abstract\\n               \\n  ...   \n",
       "1017  \\n               Abstract\\n               \\n  ...   \n",
       "1018  \\n               Abstract\\n               \\n  ...   \n",
       "1019  \\n               Abstract\\n               \\n  ...   \n",
       "102   \\n               Abstract\\n               \\n  ...   \n",
       "1020  \\n               Abstract\\n               \\n  ...   \n",
       "1021  \\n               Abstract\\n               \\n  ...   \n",
       "1022  \\n               Abstract\\n               \\n  ...   \n",
       "1023  \\n               Abstract\\n               \\n  ...   \n",
       "...                                                 ...   \n",
       "972                                                       \n",
       "973   \\n               Résumé\\n               \\n    ...   \n",
       "974   \\n               Abstract\\n               \\n  ...   \n",
       "975   \\n               Abstract\\n               \\n  ...   \n",
       "976   \\n               Abstract\\n               \\n  ...   \n",
       "977   \\n               Abstract\\n               \\n  ...   \n",
       "978   \\n               Abstract\\n               \\n  ...   \n",
       "979   \\n               Abstract\\n               \\n  ...   \n",
       "98                                                        \n",
       "980   \\n               Abstract\\n               \\n  ...   \n",
       "981   \\n               Abstract\\n               \\n  ...   \n",
       "982   \\n            Abstract\\n            \\n        ...   \n",
       "983   \\n               Abstract\\n               \\n  ...   \n",
       "984   \\n               Abstract\\n               \\n  ...   \n",
       "985   \\n               Abstract\\n               \\n  ...   \n",
       "986   \\n               Abstract\\n               \\n  ...   \n",
       "987   \\n               Abstract\\n               \\n  ...   \n",
       "988   \\n               Abstract\\n               \\n  ...   \n",
       "989   \\n               Abstract\\n               \\n  ...   \n",
       "99                                                        \n",
       "990   \\n               Abstract\\n               \\n  ...   \n",
       "991   \\n               Abstract\\n               \\n  ...   \n",
       "992   \\n               Abstract\\n               \\n  ...   \n",
       "993   \\n               \\n                  Backgroun...   \n",
       "994                                                       \n",
       "995   \\n               Abstract\\n               \\n  ...   \n",
       "996   \\n               Abstract\\n               \\n  ...   \n",
       "997   \\n               Abstract\\n               \\n  ...   \n",
       "998   \\n               Abstract\\n               \\n  ...   \n",
       "999   \\n               Abstract\\n               \\n  ...   \n",
       "\n",
       "                                                Creator  \\\n",
       "0     [Melo, Marcel, Schluter, Helga, Ferreira, Jail...   \n",
       "1     [Branco, Ricardo Castello, Baratelli, Fernando...   \n",
       "10    [Santos, Marcos Luiz Dos, Corrêa, Nelson Ferre...   \n",
       "100      [Lima, F.S.G., Araújo, M.A.S., Borges, L.E.P.]   \n",
       "1000  [Barros, Maria A.S.D., Silva, E.A., Arroyo, P....   \n",
       "1001  [Rojas, Marisol Fernández, Bernard, Franciele ...   \n",
       "1002  [Mosquera, Juan C., Ghisays, Alfredo, Montes, ...   \n",
       "1003  [Piovesan, Enelise Katia, Bergue, Cristianini ...   \n",
       "1004  [Quitete, Cristina P.B., Bittencourt, Roberto ...   \n",
       "1005  [Filgueiras, Paulo R., Sad, Cristina M.S., Lou...   \n",
       "1006  [Dalmaschio, Guilherme P., Malacarne, Majorie ...   \n",
       "1007  [Castro, Aline M., Castilho, Leda R., Freire, ...   \n",
       "1008  [Tannuri, Eduardo A., Silva, João Luis B., Ram...   \n",
       "1009  [Alves, Douglas Thiago S., de Medeiros, Jose L...   \n",
       "101   [Ferreira, Talles Souza, Araújo, Mario Neto Ca...   \n",
       "1010  [Minette, R.S., SilvaNeto, S.F., Vaz, L.A., Mo...   \n",
       "1011  [Passamonti, Francisco, de la Puente, Gabriela...   \n",
       "1012  [Calixto, Ewerton E.S., Pessoa, Fernando L.P.,...   \n",
       "1013  [Schmitt, William F., Szklo, Alexandre, Schaef...   \n",
       "1014  [dos Santos, Sidney Pereira, Eugenio Leal, Jos...   \n",
       "1015  [Melo, D.N.C., de Toledo, E.C. Vasco, Mariano,...   \n",
       "1016  [Dellagnezze, Bruna Martins, Vasconcellos, Suz...   \n",
       "1017  [Yamashita, André Shigueo, Alexandre, Paulo Ma...   \n",
       "1018  [de Paula Amaral do Valle, Pedro Wallace, Fort...   \n",
       "1019  [Menezes, Brenno C., Kelly, Jeffrey D., Grossm...   \n",
       "102   [Fonseca, Felipe A.S., Vidal-Vieira, José A., ...   \n",
       "1020  [Ibanez, Delano Menecucci, Riccomini, Claudio,...   \n",
       "1021  [Tessarolo, Nathalia S., Silva, Renzo C., Vani...   \n",
       "1022  [Magalhães, S.C., Scheid, C.M., Calçada, L.A.,...   \n",
       "1023  [Terra, Luciana A., Filgueiras, Paulo R., Tose...   \n",
       "...                                                 ...   \n",
       "972   [Abou Anoma, G., Fuks, J.-J., Sainsaulieu, F.,...   \n",
       "973   [Bensefa-Colas, L., Pineau, F., Hadengue, P., ...   \n",
       "974   [Fleury, Jean-Marc, Pubellier, Manuel, de Urre...   \n",
       "975   [Galliéro, Guillaume, Boned, Christian, Baylau...   \n",
       "976   [Garrigues, P., De Vazelhes-De Sury, R., Angel...   \n",
       "977   [Boukhicha, Rym, Charpentier, Coralie, Prod'Ho...   \n",
       "978   [Dibenedetto, Angela, Angelini, Antonella, Fas...   \n",
       "979   [Hatcher, Patrick G., Ravin, Azdine, Behar, Fr...   \n",
       "98    [Ninomiya, N., Obayashi, M., Nakamura, R., Sek...   \n",
       "980   [Cazenave, J., Seguela, R., Sixou, B., Germain...   \n",
       "981   [Parize, Olivier, Mulder, Thierry, Cahuzac, Br...   \n",
       "982   [Salzano, Ernesto, Hoorelbeke, Pol, Khan, Fais...   \n",
       "983   [Mańko, Maria, Chal, Robin, Trens, Philippe, M...   \n",
       "984   [Blanc, Ph., Lassin, A., Piantone, P., Azaroua...   \n",
       "985   [Jacquemet, Nicolas, Pironon, Jacques, Lagneau...   \n",
       "986   [DeKoninck, Philip, Gratacos, Eduardo, Van Mie...   \n",
       "987   [Faulkner, D.R., Jackson, C.A.L., Lunn, R.J., ...   \n",
       "988   [Jabbour, Majed, Dhont, Damien, Hervouët, Yves...   \n",
       "989   [Al-Huwayrini, Lujain, Al-Furiji, Samah, Al-Dh...   \n",
       "99    [Coudreuse, L., Cadilhac, B., Dumontier, C., K...   \n",
       "990   [Alaoui, F., Montero, E., Bazile, J.P., Comuña...   \n",
       "991   [Zhang, Huilong, Innal, Fares, Dufour, Françoi...   \n",
       "992        [Reijmer, J.J.G., Mulder, T., Borgomano, J.]   \n",
       "993   [Jung, Yoon Suk, Ryu, Seungho, Chang, Yoosoo, ...   \n",
       "994   [Thierfelder, Christian, Chisui, John L., Gama...   \n",
       "995   [Stricot, M., Filali, A., Lesage, N., Spérandi...   \n",
       "996   [Thierfelder, Christian, Chisui, John L., Gama...   \n",
       "997   [Eissa, Yehia, Munawwar, Saima, Oumbe, Armel, ...   \n",
       "998   [Cézac, Pierre, Serin, Jean-Paul, Reneaume, Je...   \n",
       "999   [Donot, F., Cazals, G., Gunata, Z., Egron, D.,...   \n",
       "\n",
       "                                     DOI       Date  \\\n",
       "0            10.1016/j.desal.2009.09.095 2010-01-30   \n",
       "1          10.1016/j.jbiotec.2008.07.942 2008-10-31   \n",
       "10          10.1016/0021-9797(74)90239-2 1974-06-30   \n",
       "100        10.1016/S0301-679X(03)00028-8 2003-09-30   \n",
       "1000           10.1016/j.ces.2004.07.040 2004-12-31   \n",
       "1001       10.1016/j.molcata.2014.05.007 2014-10-31   \n",
       "1002       10.1016/S0016-7169(13)71475-2 2013-09-30   \n",
       "1003        10.1016/j.palaeo.2015.02.015 2015-04-15   \n",
       "1004        10.1016/j.catcom.2015.08.013 2015-11-05   \n",
       "1005          10.1016/j.fuel.2013.07.122 2014-01-15   \n",
       "1006          10.1016/j.fuel.2013.07.008 2014-01-31   \n",
       "1007           10.1016/j.bej.2014.10.016 2015-01-15   \n",
       "1008    10.3182/20100915-3-DE-3008.00052 2010-09-30   \n",
       "1009           10.1016/j.jlp.2016.03.026 2016-05-31   \n",
       "101      10.1016/j.marpetgeo.2014.02.012 2014-06-30   \n",
       "1010      10.1016/j.oceaneng.2016.07.054 2016-09-15   \n",
       "1011           10.1016/j.cej.2011.12.081 2012-02-15   \n",
       "1012  10.1016/B978-0-444-63428-3.50337-4 2016-12-31   \n",
       "1013         10.1016/j.enpol.2011.02.067 2011-06-30   \n",
       "1014         10.1016/j.enpol.2011.06.047 2011-09-30   \n",
       "1015    10.3182/20070606-3-MX-2915.00110 2007-12-31   \n",
       "1016           10.1016/j.bjm.2016.04.004 2016-09-30   \n",
       "1017    10.1016/j.conengprac.2016.02.003 2016-05-31   \n",
       "1018      10.1016/j.biombioe.2016.03.036 2016-08-31   \n",
       "1019   10.1016/j.compchemeng.2015.05.013 2015-09-02   \n",
       "102       10.1016/j.biortech.2010.05.077 2010-11-30   \n",
       "1020      10.1016/j.geomorph.2014.02.019 2014-06-01   \n",
       "1021        10.1016/j.microc.2014.06.006 2014-11-30   \n",
       "1022         10.1016/j.jngse.2016.02.001 2016-03-31   \n",
       "1023          10.1016/j.fuel.2015.07.099 2015-11-15   \n",
       "...                                  ...        ...   \n",
       "972           10.1016/j.admp.2012.03.433 2012-06-30   \n",
       "973           10.1016/j.admp.2009.02.012 2009-04-30   \n",
       "974         10.1016/j.lithos.2009.07.007 2009-11-30   \n",
       "975       10.1016/j.chemphys.2007.02.002 2007-03-30   \n",
       "976         10.1016/0146-6380(84)90105-0 1984-12-31   \n",
       "977            10.1016/j.tsf.2013.08.014 2014-03-31   \n",
       "978           10.1016/j.jcou.2014.10.002 2014-12-31   \n",
       "979     10.1016/j.orggeochem.2014.05.016 2014-10-31   \n",
       "98            10.1016/j.jsxm.2018.03.068 2018-06-30   \n",
       "980        10.1016/j.polymer.2006.03.094 2006-05-17   \n",
       "981           10.1016/j.crte.2008.03.004 2008-06-30   \n",
       "982   10.1016/B978-0-444-54323-3.00004-X 2013-12-31   \n",
       "983      10.1016/j.micromeso.2012.12.016 2013-04-30   \n",
       "984      10.1016/j.apgeochem.2012.06.002 2012-10-31   \n",
       "985      10.1016/j.apgeochem.2011.12.004 2012-03-31   \n",
       "986     10.1016/j.earlhumdev.2011.08.001 2011-09-30   \n",
       "987            10.1016/j.jsg.2010.06.009 2010-11-30   \n",
       "988            10.1016/j.jsg.2012.05.002 2012-09-30   \n",
       "989         10.1016/j.sdentj.2013.05.001 2013-07-31   \n",
       "99             10.1533/9781845693244.100 2007-12-31   \n",
       "990          10.1016/j.fluid.2012.02.007 2012-04-25   \n",
       "991           10.1016/j.ress.2014.01.016 2014-06-30   \n",
       "992         10.1016/j.sedgeo.2014.12.001 2015-03-15   \n",
       "993            10.1016/j.gie.2014.09.031 2015-03-31   \n",
       "994            10.1016/j.fcr.2013.01.004 2013-02-20   \n",
       "995         10.1016/j.watres.2009.12.021 2010-04-30   \n",
       "996            10.1016/j.fcr.2012.11.010 2013-02-20   \n",
       "997        10.1016/j.solener.2015.01.017 2015-04-30   \n",
       "998         10.1016/j.supflu.2007.11.005 2008-03-31   \n",
       "999        10.1016/j.jchromb.2013.10.016 2013-12-30   \n",
       "\n",
       "                                               Keywords  \\\n",
       "0     [Reverse osmosis, Nanofiltration, Produced wat...   \n",
       "1                                                    []   \n",
       "10                                                   []   \n",
       "100   [Lubricant base oils, Carcinogenic potential, ...   \n",
       "1000  [Ion exchange, Zeolite, Modeling, Breakthrough...   \n",
       "1001  [CO2 utilization, Poly(ionic liquid)s, Ionomer...   \n",
       "1002  [caso histórico, modelado de pozo, tendencia d...   \n",
       "1003  [Palaeocology, Ostracods, Diversity, Sequence ...   \n",
       "1004  [Coking resistance, Nickel, Hexaaluminate, Tar...   \n",
       "1005  [Crude oil, ATR-FTIR, Partial least squares re...   \n",
       "1006  [Petroleomics, Distillation system, Mass spect...   \n",
       "1007  [Production of amylases, proteases, xylanases ...   \n",
       "1008  [Dynamic Positioning, Crane Barge, Hydrodynami...   \n",
       "1009  [Risk to general public, Major accident hazard...   \n",
       "101   [Cumuruxatiba basin, Contractional Cenozoic sa...   \n",
       "1010  [Output-only modal analysis, Integration tests...   \n",
       "1011  [FCC, Catalyst evaluation, FFB, CREC Riser Sim...   \n",
       "1012  [H2S Scavenger, H2S Scavenger Software, Crude ...   \n",
       "1013  [Vehicle efficiency, GHG emissions, Land use c...   \n",
       "1014  [Natural gas industry, Investment analysis, Pl...   \n",
       "1015  [optimization, two-layer approach, genetic alg...   \n",
       "1016  [Bacterial diversity, Microbial enrichment, Pe...   \n",
       "1017  [Model predictive controller tuning, Reference...   \n",
       "1018  [Doehlert design, Hydrated ethanol, Phase evol...   \n",
       "1019  [Oil-refinery production, Investment planning,...   \n",
       "102   [Biodiesel, Transesterification, Simulation, R...   \n",
       "1020  [Central Amazonia, Tectonics, Water loading, B...   \n",
       "1021                [Bio-oils, FT-ICR MS, GC×GC, TOFMS]   \n",
       "1022  [Drilling fluids, Acoustic parameters, Hydraul...   \n",
       "1023  [LDI, Petroleomics, CARSPLS, Crude oil, Basic ...   \n",
       "...                                                 ...   \n",
       "972                                                  []   \n",
       "973   [Benzène, Acide trans,trans-muconique, Citerni...   \n",
       "974   [Subduction blocking, Subduction jump, Asperit...   \n",
       "975   [Molecular dynamics, Mie and exponential poten...   \n",
       "976   [methyl-PAH, Shpol'skii-luminescence, maturity...   \n",
       "977   [Transparent conductive oxide, Laser annealing...   \n",
       "978   [Alcoholysis of urea, Diethylcarbonate, Interm...   \n",
       "979   [Early diagenesis, Sedimentary organic matter,...   \n",
       "98                                                   []   \n",
       "980   [Polyethylene, Molecular architecture, Stress ...   \n",
       "981   [Stratotypes, Aquitanian, Burdigalian, Sedimen...   \n",
       "982   [Blast load, Domino effect, Explosion, Loss of...   \n",
       "983   [Quasi-equilibrated thermodesorption, Hierarch...   \n",
       "984                                                  []   \n",
       "985                                                  []   \n",
       "986   [Congenital diaphragmatic hernia, Fetal interv...   \n",
       "987   [Faults, Structure, Fluid flow, Mechanics, Ear...   \n",
       "988   [Fault-propagation fold, Variable interlimb an...   \n",
       "989   [Dentists, Antibiotics’ knowledge, Antibiotics...   \n",
       "99                                                   []   \n",
       "990   [1-Hexanol, Density, High pressure, Isobaric t...   \n",
       "991   [Dynamic reliability, Piecewise Deterministic ...   \n",
       "992   [Carbonate slopes, Gravity deposits, Sedimenta...   \n",
       "993                                                  []   \n",
       "994                                                  []   \n",
       "995   [Membrane bioreactor, Side-stream configuratio...   \n",
       "996   [Sustainability, No-tillage, Direct seeding, R...   \n",
       "997       [Aerosols, Atmosphere, MACC, Solar radiation]   \n",
       "998   [Modelling, Solid–gas equilibrium, Natural gas...   \n",
       "999   [Neutral lipids, Microalgae, HPLC, ELSD, APCI-...   \n",
       "\n",
       "                                                  Title  O&G  Affiliate  \n",
       "0     Advanced performance evaluation of a reverse o...    1  Petrobras  \n",
       "1                  Petrobras’ developments in biofuels     1  Petrobras  \n",
       "10    Interaction of polyethylene with isobutane, is...    1  Petrobras  \n",
       "100   Determination of the carcinogenic potential of...    1  Petrobras  \n",
       "1000  Removal of Cr(III) in the fixed bed column and...    1  Petrobras  \n",
       "1001  Poly(ionic liquid)s as efficient catalyst in t...    1  Petrobras  \n",
       "1002  AVO analysis with partial stacking to detect g...    1  Petrobras  \n",
       "1003  Palaeoecology of ostracods from the Late Creta...    1  Petrobras  \n",
       "1004  Coking resistance evaluation of tar removal ca...    1  Petrobras  \n",
       "1005  Determination of API gravity, kinematic viscos...    1  Petrobras  \n",
       "1006  Characterization of polar compounds in a true ...    1  Petrobras  \n",
       "1007  Performance of a fixed-bed solid-state ferment...    1  Petrobras  \n",
       "1008  Methodology for evaluating DP crane-barge oper...    1  Petrobras  \n",
       "1009  Optimal determination of chemical plant layout...    1  Petrobras  \n",
       "101   Cenozoic folding in the Cumuruxatiba basin, Br...    1  Petrobras  \n",
       "1010  Experimental modal analysis of electrical subm...    1  Petrobras  \n",
       "1011  Comparison between fixed fluidized bed (FFB) a...    1  Petrobras  \n",
       "1012  A New Technology to Optimize the Use of H2S Sc...    1  Petrobras  \n",
       "1013  Policies for improving the efficiency of the B...    1  Petrobras  \n",
       "1014  The development of a natural gas transportatio...    1  Petrobras  \n",
       "1015  AN APPROACH TO OPTIMIZATION OF A THREE PHASE C...    1  Petrobras  \n",
       "1016  Evaluation of bacterial diversity recovered fr...    1  Petrobras  \n",
       "1017  Reference trajectory tuning of model predictiv...    1  Petrobras  \n",
       "1018  A systematic multivariate analysis of the supe...    1  Petrobras  \n",
       "1019  Generalized capital investment planning of oil...    1  Petrobras  \n",
       "102   Transesterification of vegetable oils: Simulat...    1  Petrobras  \n",
       "1020  Geomorphological evidence of recent tilting in...    1  Petrobras  \n",
       "1021  Assessing the chemical composition of bio-oils...    1  Petrobras  \n",
       "1022  Real time prediction of suspended solids in dr...    1  Petrobras  \n",
       "1023  Laser desorption ionization FT-ICR mass spectr...    1  Petrobras  \n",
       "...                                                 ...  ...        ...  \n",
       "972   Évaluation de l’exposition au benzène d’une co...    1      Total  \n",
       "973   Exposition professionnelle au benzène dans le ...    1      Total  \n",
       "974   Structural expression of forearc crust uplift ...    1      Total  \n",
       "975   Influence of the repulsive coefficient α and a...    1      Total  \n",
       "976   Analysis of series of aromatic isomers by high...    1      Total  \n",
       "977   Influence of sputtering conditions on the opti...    1      Total  \n",
       "978   The reaction mechanism in the ethanolysis of u...    1      Total  \n",
       "979   Diagenesis of organic matter in a 400 m organi...    1      Total  \n",
       "98    077 On the Initial Treatment Experience of CO2...    1      Total  \n",
       "980   Short-term mechanical and structural approache...    1      Total  \n",
       "981   Sedimentology and sequence stratigraphy of Aqu...    1      Total  \n",
       "982                             4 Overpressure Effects     1      Total  \n",
       "983   Porosity of micro–mesoporous zeolites prepared...    1      Total  \n",
       "984   Thermoddem: A geochemical database focused on ...    1      Total  \n",
       "985   Armouring of well cement in H2S–CO2 saturated ...    1      Total  \n",
       "986   Results of Fetal Endoscopic Tracheal Occlusion...    1      Total  \n",
       "987   A review of recent developments concerning the...    1      Total  \n",
       "988   Geometry and kinematics of fault-propagation f...    1      Total  \n",
       "989   Knowledge of antibiotics among dentists in Riy...    1      Total  \n",
       "99    10 Disbonding test methodology: Definition of ...    1      Total  \n",
       "990   Liquid density of oxygenated additives to bio-...    1      Total  \n",
       "991   Piecewise Deterministic Markov Processes based...    1      Total  \n",
       "992              Carbonate slopes and gravity deposits     1      Total  \n",
       "993   Risk factors for colorectal neoplasia in perso...    1      Total  \n",
       "994   Corrigendum to: Maize-based conservation agric...    1      Total  \n",
       "995   Side-stream membrane bioreactors: Influence of...    1      Total  \n",
       "996   Maize-based conservation agriculture systems i...    1      Total  \n",
       "997   Validating surface downwelling solar irradianc...    1      Total  \n",
       "998   Elemental sulphur deposition in natural gas tr...    1      Total  \n",
       "999   Analysis of neutral lipids from microalgae by ...    1      Total  \n",
       "\n",
       "[16349 rows x 8 columns]"
      ]
     },
     "execution_count": 33,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Lendo os arquivos da demais Majors\n",
    "abstract = abstract_petrobras\n",
    "companies = [\"BP America\",\n",
    "             \"BP Exploration\",\n",
    "             \"BP International\",\n",
    "             \"BP United Kingdom\",\n",
    "             \"British Petroleum\",\n",
    "             \"Chevron\",\n",
    "             \"Eni\",\n",
    "             \"Equinor\",\n",
    "             \"Exxon\",\n",
    "             \"Repsol\",\n",
    "             \"Shell\",\n",
    "             \"Statoil\",\n",
    "             \"Total\"]\n",
    "\n",
    "for company in companies:\n",
    "    path = \"Elsevier_abstracts - \" + company + \".json\"\n",
    "    abstract_company = pd.read_json(path_or_buf = path)\n",
    "    abstract_company['O&G'] = 1\n",
    "    abstract_company['Affiliate'] = company\n",
    "    abstract = pd.concat([abstract, abstract_company])\n",
    "    \n",
    "abstract"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 34,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Abstract</th>\n",
       "      <th>Creator</th>\n",
       "      <th>DOI</th>\n",
       "      <th>Date</th>\n",
       "      <th>Keywords</th>\n",
       "      <th>Title</th>\n",
       "      <th>O&amp;G</th>\n",
       "      <th>Affiliate</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Melo, Marcel, Schluter, Helga, Ferreira, Jail...</td>\n",
       "      <td>10.1016/j.desal.2009.09.095</td>\n",
       "      <td>2010-01-30</td>\n",
       "      <td>[Reverse osmosis, Nanofiltration, Produced wat...</td>\n",
       "      <td>Advanced performance evaluation of a reverse o...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td></td>\n",
       "      <td>[Branco, Ricardo Castello, Baratelli, Fernando...</td>\n",
       "      <td>10.1016/j.jbiotec.2008.07.942</td>\n",
       "      <td>2008-10-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>Petrobras’ developments in biofuels</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Santos, Marcos Luiz Dos, Corrêa, Nelson Ferre...</td>\n",
       "      <td>10.1016/0021-9797(74)90239-2</td>\n",
       "      <td>1974-06-30</td>\n",
       "      <td>[]</td>\n",
       "      <td>Interaction of polyethylene with isobutane, is...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Lima, F.S.G., Araújo, M.A.S., Borges, L.E.P.]</td>\n",
       "      <td>10.1016/S0301-679X(03)00028-8</td>\n",
       "      <td>2003-09-30</td>\n",
       "      <td>[Lubricant base oils, Carcinogenic potential, ...</td>\n",
       "      <td>Determination of the carcinogenic potential of...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Barros, Maria A.S.D., Silva, E.A., Arroyo, P....</td>\n",
       "      <td>10.1016/j.ces.2004.07.040</td>\n",
       "      <td>2004-12-31</td>\n",
       "      <td>[Ion exchange, Zeolite, Modeling, Breakthrough...</td>\n",
       "      <td>Removal of Cr(III) in the fixed bed column and...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Rojas, Marisol Fernández, Bernard, Franciele ...</td>\n",
       "      <td>10.1016/j.molcata.2014.05.007</td>\n",
       "      <td>2014-10-31</td>\n",
       "      <td>[CO2 utilization, Poly(ionic liquid)s, Ionomer...</td>\n",
       "      <td>Poly(ionic liquid)s as efficient catalyst in t...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Mosquera, Juan C., Ghisays, Alfredo, Montes, ...</td>\n",
       "      <td>10.1016/S0016-7169(13)71475-2</td>\n",
       "      <td>2013-09-30</td>\n",
       "      <td>[caso histórico, modelado de pozo, tendencia d...</td>\n",
       "      <td>AVO analysis with partial stacking to detect g...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Piovesan, Enelise Katia, Bergue, Cristianini ...</td>\n",
       "      <td>10.1016/j.palaeo.2015.02.015</td>\n",
       "      <td>2015-04-15</td>\n",
       "      <td>[Palaeocology, Ostracods, Diversity, Sequence ...</td>\n",
       "      <td>Palaeoecology of ostracods from the Late Creta...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Quitete, Cristina P.B., Bittencourt, Roberto ...</td>\n",
       "      <td>10.1016/j.catcom.2015.08.013</td>\n",
       "      <td>2015-11-05</td>\n",
       "      <td>[Coking resistance, Nickel, Hexaaluminate, Tar...</td>\n",
       "      <td>Coking resistance evaluation of tar removal ca...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Filgueiras, Paulo R., Sad, Cristina M.S., Lou...</td>\n",
       "      <td>10.1016/j.fuel.2013.07.122</td>\n",
       "      <td>2014-01-15</td>\n",
       "      <td>[Crude oil, ATR-FTIR, Partial least squares re...</td>\n",
       "      <td>Determination of API gravity, kinematic viscos...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Dalmaschio, Guilherme P., Malacarne, Majorie ...</td>\n",
       "      <td>10.1016/j.fuel.2013.07.008</td>\n",
       "      <td>2014-01-31</td>\n",
       "      <td>[Petroleomics, Distillation system, Mass spect...</td>\n",
       "      <td>Characterization of polar compounds in a true ...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Castro, Aline M., Castilho, Leda R., Freire, ...</td>\n",
       "      <td>10.1016/j.bej.2014.10.016</td>\n",
       "      <td>2015-01-15</td>\n",
       "      <td>[Production of amylases, proteases, xylanases ...</td>\n",
       "      <td>Performance of a fixed-bed solid-state ferment...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Tannuri, Eduardo A., Silva, João Luis B., Ram...</td>\n",
       "      <td>10.3182/20100915-3-DE-3008.00052</td>\n",
       "      <td>2010-09-30</td>\n",
       "      <td>[Dynamic Positioning, Crane Barge, Hydrodynami...</td>\n",
       "      <td>Methodology for evaluating DP crane-barge oper...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Alves, Douglas Thiago S., de Medeiros, Jose L...</td>\n",
       "      <td>10.1016/j.jlp.2016.03.026</td>\n",
       "      <td>2016-05-31</td>\n",
       "      <td>[Risk to general public, Major accident hazard...</td>\n",
       "      <td>Optimal determination of chemical plant layout...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Ferreira, Talles Souza, Araújo, Mario Neto Ca...</td>\n",
       "      <td>10.1016/j.marpetgeo.2014.02.012</td>\n",
       "      <td>2014-06-30</td>\n",
       "      <td>[Cumuruxatiba basin, Contractional Cenozoic sa...</td>\n",
       "      <td>Cenozoic folding in the Cumuruxatiba basin, Br...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Minette, R.S., SilvaNeto, S.F., Vaz, L.A., Mo...</td>\n",
       "      <td>10.1016/j.oceaneng.2016.07.054</td>\n",
       "      <td>2016-09-15</td>\n",
       "      <td>[Output-only modal analysis, Integration tests...</td>\n",
       "      <td>Experimental modal analysis of electrical subm...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Passamonti, Francisco, de la Puente, Gabriela...</td>\n",
       "      <td>10.1016/j.cej.2011.12.081</td>\n",
       "      <td>2012-02-15</td>\n",
       "      <td>[FCC, Catalyst evaluation, FFB, CREC Riser Sim...</td>\n",
       "      <td>Comparison between fixed fluidized bed (FFB) a...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Calixto, Ewerton E.S., Pessoa, Fernando L.P.,...</td>\n",
       "      <td>10.1016/B978-0-444-63428-3.50337-4</td>\n",
       "      <td>2016-12-31</td>\n",
       "      <td>[H2S Scavenger, H2S Scavenger Software, Crude ...</td>\n",
       "      <td>A New Technology to Optimize the Use of H2S Sc...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Schmitt, William F., Szklo, Alexandre, Schaef...</td>\n",
       "      <td>10.1016/j.enpol.2011.02.067</td>\n",
       "      <td>2011-06-30</td>\n",
       "      <td>[Vehicle efficiency, GHG emissions, Land use c...</td>\n",
       "      <td>Policies for improving the efficiency of the B...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[dos Santos, Sidney Pereira, Eugenio Leal, Jos...</td>\n",
       "      <td>10.1016/j.enpol.2011.06.047</td>\n",
       "      <td>2011-09-30</td>\n",
       "      <td>[Natural gas industry, Investment analysis, Pl...</td>\n",
       "      <td>The development of a natural gas transportatio...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Melo, D.N.C., de Toledo, E.C. Vasco, Mariano,...</td>\n",
       "      <td>10.3182/20070606-3-MX-2915.00110</td>\n",
       "      <td>2007-12-31</td>\n",
       "      <td>[optimization, two-layer approach, genetic alg...</td>\n",
       "      <td>AN APPROACH TO OPTIMIZATION OF A THREE PHASE C...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Dellagnezze, Bruna Martins, Vasconcellos, Suz...</td>\n",
       "      <td>10.1016/j.bjm.2016.04.004</td>\n",
       "      <td>2016-09-30</td>\n",
       "      <td>[Bacterial diversity, Microbial enrichment, Pe...</td>\n",
       "      <td>Evaluation of bacterial diversity recovered fr...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Yamashita, André Shigueo, Alexandre, Paulo Ma...</td>\n",
       "      <td>10.1016/j.conengprac.2016.02.003</td>\n",
       "      <td>2016-05-31</td>\n",
       "      <td>[Model predictive controller tuning, Reference...</td>\n",
       "      <td>Reference trajectory tuning of model predictiv...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[de Paula Amaral do Valle, Pedro Wallace, Fort...</td>\n",
       "      <td>10.1016/j.biombioe.2016.03.036</td>\n",
       "      <td>2016-08-31</td>\n",
       "      <td>[Doehlert design, Hydrated ethanol, Phase evol...</td>\n",
       "      <td>A systematic multivariate analysis of the supe...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Menezes, Brenno C., Kelly, Jeffrey D., Grossm...</td>\n",
       "      <td>10.1016/j.compchemeng.2015.05.013</td>\n",
       "      <td>2015-09-02</td>\n",
       "      <td>[Oil-refinery production, Investment planning,...</td>\n",
       "      <td>Generalized capital investment planning of oil...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Fonseca, Felipe A.S., Vidal-Vieira, José A., ...</td>\n",
       "      <td>10.1016/j.biortech.2010.05.077</td>\n",
       "      <td>2010-11-30</td>\n",
       "      <td>[Biodiesel, Transesterification, Simulation, R...</td>\n",
       "      <td>Transesterification of vegetable oils: Simulat...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Ibanez, Delano Menecucci, Riccomini, Claudio,...</td>\n",
       "      <td>10.1016/j.geomorph.2014.02.019</td>\n",
       "      <td>2014-06-01</td>\n",
       "      <td>[Central Amazonia, Tectonics, Water loading, B...</td>\n",
       "      <td>Geomorphological evidence of recent tilting in...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Tessarolo, Nathalia S., Silva, Renzo C., Vani...</td>\n",
       "      <td>10.1016/j.microc.2014.06.006</td>\n",
       "      <td>2014-11-30</td>\n",
       "      <td>[Bio-oils, FT-ICR MS, GC×GC, TOFMS]</td>\n",
       "      <td>Assessing the chemical composition of bio-oils...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Magalhães, S.C., Scheid, C.M., Calçada, L.A.,...</td>\n",
       "      <td>10.1016/j.jngse.2016.02.001</td>\n",
       "      <td>2016-03-31</td>\n",
       "      <td>[Drilling fluids, Acoustic parameters, Hydraul...</td>\n",
       "      <td>Real time prediction of suspended solids in dr...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Terra, Luciana A., Filgueiras, Paulo R., Tose...</td>\n",
       "      <td>10.1016/j.fuel.2015.07.099</td>\n",
       "      <td>2015-11-15</td>\n",
       "      <td>[LDI, Petroleomics, CARSPLS, Crude oil, Basic ...</td>\n",
       "      <td>Laser desorption ionization FT-ICR mass spectr...</td>\n",
       "      <td>1</td>\n",
       "      <td>Petrobras</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35312</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Donovan, D.P, Van Lammeren, A.C.A.P]</td>\n",
       "      <td>10.1016/S1464-1909(99)00136-7</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>Combined lidar and radar cloud particle effect...</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35313</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Bakan, S, Jost, V, Fennig, K]</td>\n",
       "      <td>10.1016/S1464-1909(99)00137-9</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>Satellite derived water balance climatology fo...</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35314</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Qian, Budong, Corte-Real, João, Xu, Hong]</td>\n",
       "      <td>10.1016/S1464-1909(99)00138-0</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>Nonseasonal variability of monthly mean sea le...</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35315</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Venema, Victor, Russchenberg, Hermann, Apitul...</td>\n",
       "      <td>10.1016/S1464-1909(99)00139-2</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>Cloud boundary height measurements using lidar...</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35316</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Lehmann, A, Hinrichsen, H.-H]</td>\n",
       "      <td>10.1016/S1464-1909(99)00140-9</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>On the wind driven and thermohaline circulatio...</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35317</th>\n",
       "      <td></td>\n",
       "      <td>[]</td>\n",
       "      <td>10.1016/S1464-1909(99)00141-0</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>Introduction to papers on “Energy and water cy...</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35318</th>\n",
       "      <td></td>\n",
       "      <td>[Martínez-González, Miguel A., Gual, Pilar, Ir...</td>\n",
       "      <td>10.1016/S0025-7753(00)71533-8</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>Cartas al editor</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35319</th>\n",
       "      <td></td>\n",
       "      <td>[Canora Lebrato, Jesús, Bermúdez García, José ...</td>\n",
       "      <td>10.1016/S0025-7753(00)71534-X</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>Antipsicóticos atípicos y síndrome neuroléptic...</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35320</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Lebedev, E.B, Kadik, A.A]</td>\n",
       "      <td>10.1016/S1464-1895(00)00089-2</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>High-temperature centrifuge simulation- new me...</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35321</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Apituley, Arnoud, van Lammeren, André, Russch...</td>\n",
       "      <td>10.1016/S1464-1909(99)00135-5</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>High time resolution cloud measurements with l...</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35322</th>\n",
       "      <td></td>\n",
       "      <td>[Rozman, Ciril]</td>\n",
       "      <td>10.1016/S0025-7753(00)71567-3</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>Universidad de Ciencias de la Salud: ¿una opci...</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35323</th>\n",
       "      <td></td>\n",
       "      <td>[Medina, Gema, Sewter, Ciaran, Vidal Puig, Ant...</td>\n",
       "      <td>10.1016/S0025-7753(00)71569-7</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>PPARγ y tiazolidinedionas, algo más que un tra...</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35324</th>\n",
       "      <td>\\n               Publisher Summary\\n          ...</td>\n",
       "      <td>[Péter, Imre]</td>\n",
       "      <td>10.1016/S1464-3456(00)80024-1</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>3.1. Thermoanalytical methods</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35325</th>\n",
       "      <td></td>\n",
       "      <td>[]</td>\n",
       "      <td>10.1016/S1464-3456(00)80050-2</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>Subject index</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35326</th>\n",
       "      <td>Unknown</td>\n",
       "      <td>[]</td>\n",
       "      <td>10.1016/B978-0-7506-4115-9.50001-9</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>By the same authors</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35327</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Lin, Herbert]</td>\n",
       "      <td>10.1016/S0740-624X(99)00024-6</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>Fluency with information technology∗\\n        ...</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35328</th>\n",
       "      <td></td>\n",
       "      <td>[Shuler, John A, Mon, Lorri]</td>\n",
       "      <td>10.1016/S0740-624X(99)00025-8</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>Reviews</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35329</th>\n",
       "      <td>\\n            I am an owner of the leading hot...</td>\n",
       "      <td>[Medlik, S., Ingram, H.]</td>\n",
       "      <td>10.1016/B978-0-7506-4115-9.50007-X</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>Chapter 3 Hotel Policies, Philosophies and Str...</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35330</th>\n",
       "      <td>\\n            The aim of this chapter1 is to o...</td>\n",
       "      <td>[Medlik, S., Ingram, H.]</td>\n",
       "      <td>10.1016/B978-0-7506-4115-9.50006-8</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>Chapter 2 Hotel Products and Markets</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35331</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Khristoforova, N.N, Khristoforov, A.V, Muslim...</td>\n",
       "      <td>10.1016/S1464-1895(00)00090-9</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>Temperature distribution and anomalies in the ...</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35332</th>\n",
       "      <td>\\n               Publisher Summary\\n          ...</td>\n",
       "      <td>[Görög, Sándor]</td>\n",
       "      <td>10.1016/S1464-3456(00)80001-0</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>Preface</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35333</th>\n",
       "      <td></td>\n",
       "      <td>[]</td>\n",
       "      <td>10.1016/S1464-3456(00)80002-2</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>List of contributors</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35334</th>\n",
       "      <td>\\n               Publisher Summary\\n          ...</td>\n",
       "      <td>[Görög, Sándor]</td>\n",
       "      <td>10.1016/S1464-3456(00)80003-4</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.1. Introductory remarks</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35335</th>\n",
       "      <td>\\n               Publisher Summary\\n          ...</td>\n",
       "      <td>[Görög, Sándor]</td>\n",
       "      <td>10.1016/S1464-3456(00)80004-6</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.2 The nature and origin of the impurities in...</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35336</th>\n",
       "      <td>\\n               Publisher Summary\\n          ...</td>\n",
       "      <td>[Lee, Richard]</td>\n",
       "      <td>10.1016/S1464-3456(00)80005-8</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.3. Toxicological aspects</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35337</th>\n",
       "      <td>\\n               Publisher Summary\\n          ...</td>\n",
       "      <td>[Görög, Sándor]</td>\n",
       "      <td>10.1016/S1464-3456(00)80006-X</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>1.4. The role of impurity profiling in drug re...</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35338</th>\n",
       "      <td>\\n               Publisher Summary\\n          ...</td>\n",
       "      <td>[Görög, Sándor]</td>\n",
       "      <td>10.1016/S1464-3456(00)80009-5</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>2.2. UV-VIS spectroscopy and fluorimetry</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35339</th>\n",
       "      <td>\\n               Publisher Summary\\n          ...</td>\n",
       "      <td>[Mák, Marianna, Czira, Gábor, Brlik, János]</td>\n",
       "      <td>10.1016/S1464-3456(00)80010-1</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>2.3. Mass spectrometry in impurity profiling</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35340</th>\n",
       "      <td>\\n               Publisher Summary\\n          ...</td>\n",
       "      <td>[Szántay, Csaba, Demeter, Ádám]</td>\n",
       "      <td>10.1016/S1464-3456(00)80011-3</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>2.4. NMR spectroscopy</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>35341</th>\n",
       "      <td>\\n               Abstract\\n               \\n  ...</td>\n",
       "      <td>[Sprehe, J.Timothy]</td>\n",
       "      <td>10.1016/S0740-624X(99)00022-2</td>\n",
       "      <td>2000-12-31</td>\n",
       "      <td>[]</td>\n",
       "      <td>Integrating records management into informatio...</td>\n",
       "      <td>0</td>\n",
       "      <td>outros</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>35342 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                                                Abstract  \\\n",
       "0      \\n               Abstract\\n               \\n  ...   \n",
       "1                                                          \n",
       "2      \\n               Abstract\\n               \\n  ...   \n",
       "3      \\n               Abstract\\n               \\n  ...   \n",
       "4      \\n               Abstract\\n               \\n  ...   \n",
       "5      \\n               Abstract\\n               \\n  ...   \n",
       "6      \\n               Abstract\\n               \\n  ...   \n",
       "7      \\n               Abstract\\n               \\n  ...   \n",
       "8      \\n               Abstract\\n               \\n  ...   \n",
       "9      \\n               Abstract\\n               \\n  ...   \n",
       "10     \\n               Abstract\\n               \\n  ...   \n",
       "11     \\n               Abstract\\n               \\n  ...   \n",
       "12     \\n               Abstract\\n               \\n  ...   \n",
       "13     \\n               Abstract\\n               \\n  ...   \n",
       "14     \\n               Abstract\\n               \\n  ...   \n",
       "15     \\n               Abstract\\n               \\n  ...   \n",
       "16     \\n               Abstract\\n               \\n  ...   \n",
       "17     \\n               Abstract\\n               \\n  ...   \n",
       "18     \\n               Abstract\\n               \\n  ...   \n",
       "19     \\n               Abstract\\n               \\n  ...   \n",
       "20     \\n               Abstract\\n               \\n  ...   \n",
       "21     \\n               Abstract\\n               \\n  ...   \n",
       "22     \\n               Abstract\\n               \\n  ...   \n",
       "23     \\n               Abstract\\n               \\n  ...   \n",
       "24     \\n               Abstract\\n               \\n  ...   \n",
       "25     \\n               Abstract\\n               \\n  ...   \n",
       "26     \\n               Abstract\\n               \\n  ...   \n",
       "27     \\n               Abstract\\n               \\n  ...   \n",
       "28     \\n               Abstract\\n               \\n  ...   \n",
       "29     \\n               Abstract\\n               \\n  ...   \n",
       "...                                                  ...   \n",
       "35312  \\n               Abstract\\n               \\n  ...   \n",
       "35313  \\n               Abstract\\n               \\n  ...   \n",
       "35314  \\n               Abstract\\n               \\n  ...   \n",
       "35315  \\n               Abstract\\n               \\n  ...   \n",
       "35316  \\n               Abstract\\n               \\n  ...   \n",
       "35317                                                      \n",
       "35318                                                      \n",
       "35319                                                      \n",
       "35320  \\n               Abstract\\n               \\n  ...   \n",
       "35321  \\n               Abstract\\n               \\n  ...   \n",
       "35322                                                      \n",
       "35323                                                      \n",
       "35324  \\n               Publisher Summary\\n          ...   \n",
       "35325                                                      \n",
       "35326                                            Unknown   \n",
       "35327  \\n               Abstract\\n               \\n  ...   \n",
       "35328                                                      \n",
       "35329  \\n            I am an owner of the leading hot...   \n",
       "35330  \\n            The aim of this chapter1 is to o...   \n",
       "35331  \\n               Abstract\\n               \\n  ...   \n",
       "35332  \\n               Publisher Summary\\n          ...   \n",
       "35333                                                      \n",
       "35334  \\n               Publisher Summary\\n          ...   \n",
       "35335  \\n               Publisher Summary\\n          ...   \n",
       "35336  \\n               Publisher Summary\\n          ...   \n",
       "35337  \\n               Publisher Summary\\n          ...   \n",
       "35338  \\n               Publisher Summary\\n          ...   \n",
       "35339  \\n               Publisher Summary\\n          ...   \n",
       "35340  \\n               Publisher Summary\\n          ...   \n",
       "35341  \\n               Abstract\\n               \\n  ...   \n",
       "\n",
       "                                                 Creator  \\\n",
       "0      [Melo, Marcel, Schluter, Helga, Ferreira, Jail...   \n",
       "1      [Branco, Ricardo Castello, Baratelli, Fernando...   \n",
       "2      [Santos, Marcos Luiz Dos, Corrêa, Nelson Ferre...   \n",
       "3         [Lima, F.S.G., Araújo, M.A.S., Borges, L.E.P.]   \n",
       "4      [Barros, Maria A.S.D., Silva, E.A., Arroyo, P....   \n",
       "5      [Rojas, Marisol Fernández, Bernard, Franciele ...   \n",
       "6      [Mosquera, Juan C., Ghisays, Alfredo, Montes, ...   \n",
       "7      [Piovesan, Enelise Katia, Bergue, Cristianini ...   \n",
       "8      [Quitete, Cristina P.B., Bittencourt, Roberto ...   \n",
       "9      [Filgueiras, Paulo R., Sad, Cristina M.S., Lou...   \n",
       "10     [Dalmaschio, Guilherme P., Malacarne, Majorie ...   \n",
       "11     [Castro, Aline M., Castilho, Leda R., Freire, ...   \n",
       "12     [Tannuri, Eduardo A., Silva, João Luis B., Ram...   \n",
       "13     [Alves, Douglas Thiago S., de Medeiros, Jose L...   \n",
       "14     [Ferreira, Talles Souza, Araújo, Mario Neto Ca...   \n",
       "15     [Minette, R.S., SilvaNeto, S.F., Vaz, L.A., Mo...   \n",
       "16     [Passamonti, Francisco, de la Puente, Gabriela...   \n",
       "17     [Calixto, Ewerton E.S., Pessoa, Fernando L.P.,...   \n",
       "18     [Schmitt, William F., Szklo, Alexandre, Schaef...   \n",
       "19     [dos Santos, Sidney Pereira, Eugenio Leal, Jos...   \n",
       "20     [Melo, D.N.C., de Toledo, E.C. Vasco, Mariano,...   \n",
       "21     [Dellagnezze, Bruna Martins, Vasconcellos, Suz...   \n",
       "22     [Yamashita, André Shigueo, Alexandre, Paulo Ma...   \n",
       "23     [de Paula Amaral do Valle, Pedro Wallace, Fort...   \n",
       "24     [Menezes, Brenno C., Kelly, Jeffrey D., Grossm...   \n",
       "25     [Fonseca, Felipe A.S., Vidal-Vieira, José A., ...   \n",
       "26     [Ibanez, Delano Menecucci, Riccomini, Claudio,...   \n",
       "27     [Tessarolo, Nathalia S., Silva, Renzo C., Vani...   \n",
       "28     [Magalhães, S.C., Scheid, C.M., Calçada, L.A.,...   \n",
       "29     [Terra, Luciana A., Filgueiras, Paulo R., Tose...   \n",
       "...                                                  ...   \n",
       "35312              [Donovan, D.P, Van Lammeren, A.C.A.P]   \n",
       "35313                     [Bakan, S, Jost, V, Fennig, K]   \n",
       "35314         [Qian, Budong, Corte-Real, João, Xu, Hong]   \n",
       "35315  [Venema, Victor, Russchenberg, Hermann, Apitul...   \n",
       "35316                     [Lehmann, A, Hinrichsen, H.-H]   \n",
       "35317                                                 []   \n",
       "35318  [Martínez-González, Miguel A., Gual, Pilar, Ir...   \n",
       "35319  [Canora Lebrato, Jesús, Bermúdez García, José ...   \n",
       "35320                         [Lebedev, E.B, Kadik, A.A]   \n",
       "35321  [Apituley, Arnoud, van Lammeren, André, Russch...   \n",
       "35322                                    [Rozman, Ciril]   \n",
       "35323  [Medina, Gema, Sewter, Ciaran, Vidal Puig, Ant...   \n",
       "35324                                      [Péter, Imre]   \n",
       "35325                                                 []   \n",
       "35326                                                 []   \n",
       "35327                                     [Lin, Herbert]   \n",
       "35328                       [Shuler, John A, Mon, Lorri]   \n",
       "35329                           [Medlik, S., Ingram, H.]   \n",
       "35330                           [Medlik, S., Ingram, H.]   \n",
       "35331  [Khristoforova, N.N, Khristoforov, A.V, Muslim...   \n",
       "35332                                    [Görög, Sándor]   \n",
       "35333                                                 []   \n",
       "35334                                    [Görög, Sándor]   \n",
       "35335                                    [Görög, Sándor]   \n",
       "35336                                     [Lee, Richard]   \n",
       "35337                                    [Görög, Sándor]   \n",
       "35338                                    [Görög, Sándor]   \n",
       "35339        [Mák, Marianna, Czira, Gábor, Brlik, János]   \n",
       "35340                    [Szántay, Csaba, Demeter, Ádám]   \n",
       "35341                                [Sprehe, J.Timothy]   \n",
       "\n",
       "                                      DOI        Date  \\\n",
       "0             10.1016/j.desal.2009.09.095  2010-01-30   \n",
       "1           10.1016/j.jbiotec.2008.07.942  2008-10-31   \n",
       "2            10.1016/0021-9797(74)90239-2  1974-06-30   \n",
       "3           10.1016/S0301-679X(03)00028-8  2003-09-30   \n",
       "4               10.1016/j.ces.2004.07.040  2004-12-31   \n",
       "5           10.1016/j.molcata.2014.05.007  2014-10-31   \n",
       "6           10.1016/S0016-7169(13)71475-2  2013-09-30   \n",
       "7            10.1016/j.palaeo.2015.02.015  2015-04-15   \n",
       "8            10.1016/j.catcom.2015.08.013  2015-11-05   \n",
       "9              10.1016/j.fuel.2013.07.122  2014-01-15   \n",
       "10             10.1016/j.fuel.2013.07.008  2014-01-31   \n",
       "11              10.1016/j.bej.2014.10.016  2015-01-15   \n",
       "12       10.3182/20100915-3-DE-3008.00052  2010-09-30   \n",
       "13              10.1016/j.jlp.2016.03.026  2016-05-31   \n",
       "14        10.1016/j.marpetgeo.2014.02.012  2014-06-30   \n",
       "15         10.1016/j.oceaneng.2016.07.054  2016-09-15   \n",
       "16              10.1016/j.cej.2011.12.081  2012-02-15   \n",
       "17     10.1016/B978-0-444-63428-3.50337-4  2016-12-31   \n",
       "18            10.1016/j.enpol.2011.02.067  2011-06-30   \n",
       "19            10.1016/j.enpol.2011.06.047  2011-09-30   \n",
       "20       10.3182/20070606-3-MX-2915.00110  2007-12-31   \n",
       "21              10.1016/j.bjm.2016.04.004  2016-09-30   \n",
       "22       10.1016/j.conengprac.2016.02.003  2016-05-31   \n",
       "23         10.1016/j.biombioe.2016.03.036  2016-08-31   \n",
       "24      10.1016/j.compchemeng.2015.05.013  2015-09-02   \n",
       "25         10.1016/j.biortech.2010.05.077  2010-11-30   \n",
       "26         10.1016/j.geomorph.2014.02.019  2014-06-01   \n",
       "27           10.1016/j.microc.2014.06.006  2014-11-30   \n",
       "28            10.1016/j.jngse.2016.02.001  2016-03-31   \n",
       "29             10.1016/j.fuel.2015.07.099  2015-11-15   \n",
       "...                                   ...         ...   \n",
       "35312       10.1016/S1464-1909(99)00136-7  2000-12-31   \n",
       "35313       10.1016/S1464-1909(99)00137-9  2000-12-31   \n",
       "35314       10.1016/S1464-1909(99)00138-0  2000-12-31   \n",
       "35315       10.1016/S1464-1909(99)00139-2  2000-12-31   \n",
       "35316       10.1016/S1464-1909(99)00140-9  2000-12-31   \n",
       "35317       10.1016/S1464-1909(99)00141-0  2000-12-31   \n",
       "35318       10.1016/S0025-7753(00)71533-8  2000-12-31   \n",
       "35319       10.1016/S0025-7753(00)71534-X  2000-12-31   \n",
       "35320       10.1016/S1464-1895(00)00089-2  2000-12-31   \n",
       "35321       10.1016/S1464-1909(99)00135-5  2000-12-31   \n",
       "35322       10.1016/S0025-7753(00)71567-3  2000-12-31   \n",
       "35323       10.1016/S0025-7753(00)71569-7  2000-12-31   \n",
       "35324       10.1016/S1464-3456(00)80024-1  2000-12-31   \n",
       "35325       10.1016/S1464-3456(00)80050-2  2000-12-31   \n",
       "35326  10.1016/B978-0-7506-4115-9.50001-9  2000-12-31   \n",
       "35327       10.1016/S0740-624X(99)00024-6  2000-12-31   \n",
       "35328       10.1016/S0740-624X(99)00025-8  2000-12-31   \n",
       "35329  10.1016/B978-0-7506-4115-9.50007-X  2000-12-31   \n",
       "35330  10.1016/B978-0-7506-4115-9.50006-8  2000-12-31   \n",
       "35331       10.1016/S1464-1895(00)00090-9  2000-12-31   \n",
       "35332       10.1016/S1464-3456(00)80001-0  2000-12-31   \n",
       "35333       10.1016/S1464-3456(00)80002-2  2000-12-31   \n",
       "35334       10.1016/S1464-3456(00)80003-4  2000-12-31   \n",
       "35335       10.1016/S1464-3456(00)80004-6  2000-12-31   \n",
       "35336       10.1016/S1464-3456(00)80005-8  2000-12-31   \n",
       "35337       10.1016/S1464-3456(00)80006-X  2000-12-31   \n",
       "35338       10.1016/S1464-3456(00)80009-5  2000-12-31   \n",
       "35339       10.1016/S1464-3456(00)80010-1  2000-12-31   \n",
       "35340       10.1016/S1464-3456(00)80011-3  2000-12-31   \n",
       "35341       10.1016/S0740-624X(99)00022-2  2000-12-31   \n",
       "\n",
       "                                                Keywords  \\\n",
       "0      [Reverse osmosis, Nanofiltration, Produced wat...   \n",
       "1                                                     []   \n",
       "2                                                     []   \n",
       "3      [Lubricant base oils, Carcinogenic potential, ...   \n",
       "4      [Ion exchange, Zeolite, Modeling, Breakthrough...   \n",
       "5      [CO2 utilization, Poly(ionic liquid)s, Ionomer...   \n",
       "6      [caso histórico, modelado de pozo, tendencia d...   \n",
       "7      [Palaeocology, Ostracods, Diversity, Sequence ...   \n",
       "8      [Coking resistance, Nickel, Hexaaluminate, Tar...   \n",
       "9      [Crude oil, ATR-FTIR, Partial least squares re...   \n",
       "10     [Petroleomics, Distillation system, Mass spect...   \n",
       "11     [Production of amylases, proteases, xylanases ...   \n",
       "12     [Dynamic Positioning, Crane Barge, Hydrodynami...   \n",
       "13     [Risk to general public, Major accident hazard...   \n",
       "14     [Cumuruxatiba basin, Contractional Cenozoic sa...   \n",
       "15     [Output-only modal analysis, Integration tests...   \n",
       "16     [FCC, Catalyst evaluation, FFB, CREC Riser Sim...   \n",
       "17     [H2S Scavenger, H2S Scavenger Software, Crude ...   \n",
       "18     [Vehicle efficiency, GHG emissions, Land use c...   \n",
       "19     [Natural gas industry, Investment analysis, Pl...   \n",
       "20     [optimization, two-layer approach, genetic alg...   \n",
       "21     [Bacterial diversity, Microbial enrichment, Pe...   \n",
       "22     [Model predictive controller tuning, Reference...   \n",
       "23     [Doehlert design, Hydrated ethanol, Phase evol...   \n",
       "24     [Oil-refinery production, Investment planning,...   \n",
       "25     [Biodiesel, Transesterification, Simulation, R...   \n",
       "26     [Central Amazonia, Tectonics, Water loading, B...   \n",
       "27                   [Bio-oils, FT-ICR MS, GC×GC, TOFMS]   \n",
       "28     [Drilling fluids, Acoustic parameters, Hydraul...   \n",
       "29     [LDI, Petroleomics, CARSPLS, Crude oil, Basic ...   \n",
       "...                                                  ...   \n",
       "35312                                                 []   \n",
       "35313                                                 []   \n",
       "35314                                                 []   \n",
       "35315                                                 []   \n",
       "35316                                                 []   \n",
       "35317                                                 []   \n",
       "35318                                                 []   \n",
       "35319                                                 []   \n",
       "35320                                                 []   \n",
       "35321                                                 []   \n",
       "35322                                                 []   \n",
       "35323                                                 []   \n",
       "35324                                                 []   \n",
       "35325                                                 []   \n",
       "35326                                                 []   \n",
       "35327                                                 []   \n",
       "35328                                                 []   \n",
       "35329                                                 []   \n",
       "35330                                                 []   \n",
       "35331                                                 []   \n",
       "35332                                                 []   \n",
       "35333                                                 []   \n",
       "35334                                                 []   \n",
       "35335                                                 []   \n",
       "35336                                                 []   \n",
       "35337                                                 []   \n",
       "35338                                                 []   \n",
       "35339                                                 []   \n",
       "35340                                                 []   \n",
       "35341                                                 []   \n",
       "\n",
       "                                                   Title  O&G  Affiliate  \n",
       "0      Advanced performance evaluation of a reverse o...    1  Petrobras  \n",
       "1                   Petrobras’ developments in biofuels     1  Petrobras  \n",
       "2      Interaction of polyethylene with isobutane, is...    1  Petrobras  \n",
       "3      Determination of the carcinogenic potential of...    1  Petrobras  \n",
       "4      Removal of Cr(III) in the fixed bed column and...    1  Petrobras  \n",
       "5      Poly(ionic liquid)s as efficient catalyst in t...    1  Petrobras  \n",
       "6      AVO analysis with partial stacking to detect g...    1  Petrobras  \n",
       "7      Palaeoecology of ostracods from the Late Creta...    1  Petrobras  \n",
       "8      Coking resistance evaluation of tar removal ca...    1  Petrobras  \n",
       "9      Determination of API gravity, kinematic viscos...    1  Petrobras  \n",
       "10     Characterization of polar compounds in a true ...    1  Petrobras  \n",
       "11     Performance of a fixed-bed solid-state ferment...    1  Petrobras  \n",
       "12     Methodology for evaluating DP crane-barge oper...    1  Petrobras  \n",
       "13     Optimal determination of chemical plant layout...    1  Petrobras  \n",
       "14     Cenozoic folding in the Cumuruxatiba basin, Br...    1  Petrobras  \n",
       "15     Experimental modal analysis of electrical subm...    1  Petrobras  \n",
       "16     Comparison between fixed fluidized bed (FFB) a...    1  Petrobras  \n",
       "17     A New Technology to Optimize the Use of H2S Sc...    1  Petrobras  \n",
       "18     Policies for improving the efficiency of the B...    1  Petrobras  \n",
       "19     The development of a natural gas transportatio...    1  Petrobras  \n",
       "20     AN APPROACH TO OPTIMIZATION OF A THREE PHASE C...    1  Petrobras  \n",
       "21     Evaluation of bacterial diversity recovered fr...    1  Petrobras  \n",
       "22     Reference trajectory tuning of model predictiv...    1  Petrobras  \n",
       "23     A systematic multivariate analysis of the supe...    1  Petrobras  \n",
       "24     Generalized capital investment planning of oil...    1  Petrobras  \n",
       "25     Transesterification of vegetable oils: Simulat...    1  Petrobras  \n",
       "26     Geomorphological evidence of recent tilting in...    1  Petrobras  \n",
       "27     Assessing the chemical composition of bio-oils...    1  Petrobras  \n",
       "28     Real time prediction of suspended solids in dr...    1  Petrobras  \n",
       "29     Laser desorption ionization FT-ICR mass spectr...    1  Petrobras  \n",
       "...                                                  ...  ...        ...  \n",
       "35312  Combined lidar and radar cloud particle effect...    0     outros  \n",
       "35313  Satellite derived water balance climatology fo...    0     outros  \n",
       "35314  Nonseasonal variability of monthly mean sea le...    0     outros  \n",
       "35315  Cloud boundary height measurements using lidar...    0     outros  \n",
       "35316  On the wind driven and thermohaline circulatio...    0     outros  \n",
       "35317  Introduction to papers on “Energy and water cy...    0     outros  \n",
       "35318                                  Cartas al editor     0     outros  \n",
       "35319  Antipsicóticos atípicos y síndrome neuroléptic...    0     outros  \n",
       "35320  High-temperature centrifuge simulation- new me...    0     outros  \n",
       "35321  High time resolution cloud measurements with l...    0     outros  \n",
       "35322  Universidad de Ciencias de la Salud: ¿una opci...    0     outros  \n",
       "35323  PPARγ y tiazolidinedionas, algo más que un tra...    0     outros  \n",
       "35324                     3.1. Thermoanalytical methods     0     outros  \n",
       "35325                                     Subject index     0     outros  \n",
       "35326                                By the same authors    0     outros  \n",
       "35327  Fluency with information technology∗\\n        ...    0     outros  \n",
       "35328                                           Reviews     0     outros  \n",
       "35329  Chapter 3 Hotel Policies, Philosophies and Str...    0     outros  \n",
       "35330              Chapter 2 Hotel Products and Markets     0     outros  \n",
       "35331  Temperature distribution and anomalies in the ...    0     outros  \n",
       "35332                                           Preface     0     outros  \n",
       "35333                              List of contributors     0     outros  \n",
       "35334                         1.1. Introductory remarks     0     outros  \n",
       "35335  1.2 The nature and origin of the impurities in...    0     outros  \n",
       "35336                        1.3. Toxicological aspects     0     outros  \n",
       "35337  1.4. The role of impurity profiling in drug re...    0     outros  \n",
       "35338          2.2. UV-VIS spectroscopy and fluorimetry     0     outros  \n",
       "35339      2.3. Mass spectrometry in impurity profiling     0     outros  \n",
       "35340                             2.4. NMR spectroscopy     0     outros  \n",
       "35341  Integrating records management into informatio...    0     outros  \n",
       "\n",
       "[35342 rows x 8 columns]"
      ]
     },
     "execution_count": 34,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# Lendo os arquivos de autores não filiados a empresas de O&G\n",
    "years = [\"2018\", \"2017\", \"2016\", \"2015\", \"2014\", \"2013\", \"2012\", \"2011\", \"2010\",\n",
    "         \"2009\", \"2008\", \"2007\", \"2006\", \"2005\", \"2004\", \"2003\", \"2002\", \"2001\", \"2000\"]\n",
    "\n",
    "for year in years:\n",
    "    path = \"Elsevier_abstracts - \" + year + \".json\"\n",
    "    abstract_year = pd.read_json(path_or_buf = path)\n",
    "    abstract_year['O&G'] = 0\n",
    "    abstract_year['Affiliate'] = \"outros\"\n",
    "    abstract = pd.concat([abstract, abstract_year])\n",
    "    \n",
    "abstract = abstract.reset_index()\n",
    "abstract = abstract.drop(columns=['index'])\n",
    "abstract[\"Date\"] = abstract[\"Date\"].astype(str)\n",
    "abstract"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "Salvando arquivo consolidado"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "metadata": {},
   "outputs": [],
   "source": [
    "abstract.to_json(\"Elsevier_abstract - Consolidado.json\")"
   ]
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.4"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
